Re: How do I convert a VARCHAR field to a CHAR field in a VIEW?

I'm confused.

If you want to go from 10 character names down to 6 characters then:

a) Why are you selecting the long name?

b) What has char(70) got to do with anything ?

On Aug 29, 2019, at 2:35 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I have to convert 10 character field names in a table to a 6 char field
name.

I have tried
Select long_field as char(70) from FROM_FILE.

I am getting an error that does not tell me what is does not like. I

cannot

find a solution on Google.

How do I format the command in a view?

TIA

Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com