convert numbers in SQL

ahmed_zedan · #1 (**permalink**) 01-19-06, 09:59

how can i format numbers in SQL
Eg. i have number such as 1250.000002341 in a table [money].[Paid]
how can i fornat that number to 125,00?

Peter.Vanroose · #2 (**permalink**) 01-20-06, 02:55

With the number stored in "money.paid", use

Code:

CAST(money.paid AS DECIMAL(10,2))

healdem · #3 (**permalink**) 01-20-06, 03:08

formatting is usually a function of your user interface. So its rare to come accross a requirement like this in SQL. Where are you using this information - in a report, in a screen, in a text file?

Internet Services

Web Development

Digital Marketing

Consumer Tech