I want to convert my float field (named Qty) to a float value with precision 2.
e.g. my Qty field hold 15.10000000000000001 and I wish to convert it into 15.10
I'm using SQL server 2000.
How could I write the query for this conversion.
Plz help me
Thanks
Declare @.float float|||you can also do it in the design itself and not worry abt converting everytime you use it...set the column type to decimal and set the precision to 2. that way you dont have to worry abt the conversion everytime and also not lose any values when you do a reverse conversion...
SET @.float = 2515.11111000000001-- the optional third parameter of convert if 1 or 0
-- when applied to smallmoney or money will have only 2 numbers on right side of decimal
-- you can also add commas i.e. 12000.393939
-- if 1 would be 12,000.39
-- if 0 would be 12000.39
SELECT CONVERT(varchar, CONVERT(smallmoney, @.float), 1)
hth|||Acutally I want to store the original value in the table but when i need it somewhere else then it has to be in such required conversion.
I knew ur solution but due to my requirement I'm expecting the proper query for that.
If u have the solution then plz reply me soon.
Thanks|||you can say
SELECT CONVERT(varchar, CONVERT(smallmoney, <column name>), 1) as [<column name>] from the table.
this will display the data without effecting the data base.
