February 19, 2002 at 12:59 pm
when dealing with numbers greater than 1000.00,(such as 32501.00) how do i format the number with commas and dollar signs (ie., $32,501.00)?
thanks
February 19, 2002 at 1:11 pm
If you are not storing as money datatype then try changing the datatype of the field or
CAST(fldName AS money)
Or use smallmoney based on your maximum amount. See datatypes in SQL Books Onlie for more detail about each.
February 19, 2002 at 1:27 pm
Use the covert command and a style of 1
eg.
CONVERT (CHAR(15),variable_name, 1)
William H. Hoover
Louisville, Ky
William H. Hoover
Louisville, Ky
sweeper_bill@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy