>>>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?