I am getting an error during an update query...
Error converting data type varchar to numeric.
I've tried using isnumeric to find the culprit but it shows all values as 1. I have even tried searching for . + and -.
Is there a better way to find the non-numeric value in the column?