Re: Create Table mixing referenced and explicit column definitions creating undesirable results

Dennis Lovelady wrote:

select field1, field2, char(35) as newfield, field3 from oldfile

FIELD1 FIELD2 FIELD4 FIELD3
a b 35 c
d e 35 f
g h 35 i
******** End of data ********

How about this:

select field1, field2, ' (total 35 spaces) ' as newfield, field3
from oldfile

Should do the trick.

Joe

Golly Jeepers, Joe! Glenn is not the only tired one, huh?!!? How did I miss that?!?

One of the benefits of using SQL in a live environment: these sorts of techniques become second nature <grin>. I can't tell you how many times I've needed to populate data with fixed values in fields.

Joe