select field1, field2, 0 as num_field, ' ' as char_field, ctod(' / / ') as datefield ;
from mytable ;
into table newtable

>Hi All,
>
>In the foxpro help it mentions that you can create a new 'select_item' by using a constant but fails to give you
>an example of how you do that. Can someone give me an example of a new numeric column initialized to zero for
>a table built with an SQL statement ?
>
>Thanks,
>
>Don