>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
Edward Pikman
Independent Consultant