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?With the number stored in "money.paid", useCAST(money.paid AS DECIMAL(10,2))|||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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment