Hi Rajib,

I did the following query:

SELECT ISNUMERIC(column_13) from #temp

The column brought back 0 and 1s

Again this column that has budget data. So values like 100, 105, 105.67, 9845.43, #MISS appear

I tried to do a SELECT CONVERT(numeric 18,2),column_13) AS convert_col13 INTO #temp2 from #temp but I still get error about unable to convert nvarchar to numeric