>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?
-------------
Hi Cindy and nice to hear from you again....
thanks for the code..that helps a lot...
My SELECT notes are really growing...
I have:
select_logic.txt
select_math_stuff.txt
select_date_type.txt (yours)
select_orphans.txt....::))))