Is there an easy or best way of overcoming the following error (as messaged):
Error converting data type varchar to float.
It is resulting from a INSERT statement by the way.
I've tried :
SELECT [Col001], [Col002], [Col003], cast([Col004] AS FLOAT), cast([Col005] AS FLOAT), CAST([Col006] AS FLOAT), CAST([Col007] AS FLOAT) FROM [Base_tables_Correlations_B].[dbo].[Result_Males_and_Females_DSRs] WHERE Col005 IS NOT NULL
Also I've used the Convert function without luck.