[SQL] Detecting cells in column that cause error in SQL

Assuming that we are trying to alter the type of a column in a SQL table, say from varchar to float, using: ALTER TABLE <mytable> ALTER COLUMN <mycolumn> FLOAT. However, we get the error Error to convert datatype varchar to float.

Is it possible to narrow down the cells in the column that are causing this problem?

Continue reading...