Remove Character -- a comma from a number

• martin.edward

  SSCommitted

  Points: 1645

  More actions

  August 6, 2010 at 4:38 am

  #103966

  Hi,

  I have the following figure 5,000. When I use Isnumeric () on this it returns 1 which is true however when i use

  SELECT CONVERT(decimal, '5,000') I get an error saying Error converting data type varchar to numeric.

  I have come to see that the , between 5 and 000 is the problem. Could you assist on removing this character ?

  Regards,

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  August 6, 2010 at 4:53 am

  #1203382

  SELECT CONVERT(decimal, REPLACE('5,000',',',''))

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---