>>>>Is there some way to force the type of field in a table created by SQL? I know with currency, you can do $0.00 AS ... But what about the other types.
>>>>
>
>CREATE CURSOR IntegerCursor (Field1 I) && or any type you wish.
>APPEND BLANK
>
>SELECT SomeFieldNames, Field1 AS MyNewFieldOfAnyType ;
> FROM SomeTable, IntegerCursor ;
> INTO CURSOR Result
>
>No join condition required. Does that work for you?

Interesting, but I think it's simpler just to alter the table.

Thanks,

-Michelle