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