>Hear is my SELECT statement:
>SELECT some_number AS mynumber FROM mytable
>
>the data type of mynumber is 20.8 and I would like it to be 8.4.
>any ideas?
Why do you want this?
IMNSHO, if your field structure is N(20,8) you should keep it that way or rethink your data structure.
Insanity: Doing the same thing over and over and expecting different results.