I have a table which I created by importing a flat file (using SSIS). The table is set to all nvarchar datatypes at the moment. I would like to convert the columns of the table into specific datatypes mosty numeric. However before I do this I would like to convert all the blank spaces into NULLS.
In addition, I would like to be able to perform a CREATE > INSERT a New Table out of this data and cast all the columns to numeric datatypes, while leaving the blanks NULL and not '0'.