absolute value of a float

[cards4]

Hello,
I am trying to get the absolute value of a float in my SQL query. When I run ISQL to run the query and place the results in a text file, the number still remains as a number with decimals. I'm trying everything to get rid of the decimals. Please help! Thank you.

 

[gmmastros]

If you don't want decimals, then you should convert the value to integer.

Select Convert(Int, Abs(SomeField)) As SomeField
From SomeTable

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[cards4]

That worked! Thank you very much!