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 ?