Thanks, I have been working on this still. I have figured out that I need to change the data type to nvarchar then update all the values that had NaN to 0. The problem I am having is once I'm completed on updating those values. I then change the data type to Decimal this works on the smaller tables but the ones with 200000 plus rows error out.

Any suggestions on how to get past that? I have even scripted out the table to move the data over then drop that table but that also errors out.

Thanks