I am trying to convert the data from varchar to decimal... But getting failed... got to know that there are few invalid data... But i have checked for 21 lakhs records.... can you please tell me any way to get the invalid data in a column...
here invalid data is 2q ... i want to find only invalid data... can you please tell me to write a regexp to find data other then numbers or decimal
THEN CAST('2Q' AS DECIMAL(9,0))
-----In >= TD 14