>>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.
>>
>>I have a line that says 0 AS group. The trouble is that it makes it a N(1,0). When I later try and fill the group in, I can only put single digits. I suppose I could put 00000 AS group to make it bigger, but what I really want is to make it an integer.
>>
>>Is there any way to do that?
>>
>>Thanks,
>>
>>-Michelle
>
>You may use ALTER TABLE to change data type

Brute force method, eh? Well, I suppose that'll work. I was hoping for something in the SQL.

Thanks,

-Michelle