Robert,

In general, to force a specific data type use something like:

SELECT PADR(cMyText, 30) AS cMyText
SELECT nMyValue + $0.0 AS yMyMoney
SELECT nMyValue + 000000.00 AS nMySpecificNumericValue




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