Numeric Format Using Sql Server 2000 Query

I need to Format the number 123.745817 to 123.75 by using Sql Server 2000 Query

Quote:

Originally Posted by hisham123

I need to Format the number 123.745817 to 123.75 by using Sql Server 2000 Query

select convert(decimal(5,2),123.745817 ,0)|||

Quote:

Originally Posted by Vidhura

select convert(decimal(5,2),123.745817 ,0)

For those who don't understand the syntax, read below:

decimal[(p[, s])] and numeric[(p[, s])]

Fixed precision and scale numbers. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1. The SQL-92 synonyms for decimal are dec and dec(p, s).

p (precision)

Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38. The default precision is 18.

s (scale)

Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. Scale can be specified only if precision is specified. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision.

taken from here:

http://msdn2.microsoft.com/en-us/li...32(SQL.80).aspx