>i'm makin a query
>select alltrim(field1) +alltrim(field2) from..
>into table my_table...
>
>in the table my_table i got a field called like exp_1 or exp_3
>
>how can i set a name to this field directly from my query?
This should do it:
select alltrim(field1) +alltrim(field2) as myfield from..
into table my_table...
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com