formatting numbers

• dudeski1

  SSC Journeyman

  Points: 99

  More actions

  February 19, 2002 at 12:59 pm

  #78211

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 19, 2002 at 1:11 pm

  #424147

  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.

• sweeper_bill

  Ten Centuries

  Points: 1015

  More actions

  February 19, 2002 at 1:27 pm

  #424149

  Use the covert command and a style of 1

  eg.

  CONVERT (CHAR(15),variable_name, 1)

  William H. Hoover

  Louisville, Ky

  sweeper_bill@yahoo.com

  
  William H. Hoover
  Louisville, Ky
  sweeper_bill@yahoo.com