Thanks I started to update the tables to the correct data type. Would you know of an easy way to update the value with say 400000 rows. I have one table left to update and its complaining about large size of data then errors out.

Much appreciated thanks