Remove Character -- a comma from a number

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Remove Character -- a comma from a number

Remove Character -- a comma from a number

Rate Topic

Display Mode

Topic Options

Author

Message

martin.edward

Posted Friday, August 06, 2010 4:38 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 11, 2011 12:49 AM
Points: 69, Visits: 179

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,

Post #964987

Cadavre

Posted Friday, August 06, 2010 4:53 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:16 AM
Points: 2,236, Visits: 6,486

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

Not a DBA, just trying to learn

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/

If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...
(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock

LinkedIn | Blog coming soon (for sufficiently large values of "soon" Wink

Post #964999

« Prev Topic | Next Topic »

Permissions