InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 07:44:35 GMT20http://www.sqlservercentral.com/Forums/Topic964987-145-1.aspx[code="sql"]SELECT CONVERT(decimal, REPLACE('5,000',',','')) [/code]Fri, 06 Aug 2010 04:53:40 GMTCadavrehttp://www.sqlservercentral.com/Forums/Topic964987-145-1.aspxHi,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,Fri, 06 Aug 2010 04:38:27 GMTmartin.edward