I created a table using sql, and I accidentally made one of the fields a money datatype and I meant to make it a Varchar(50). Is there an easy way to change the datatype with an sql update/convert statement. I want to make the change permanent. As I need it to reflect on a couple of different databases with this same table name. Here is the update statement I have been trying.
update ibapoorderline set salestype=convert(varchar(50),salestype)
There is currently no data stored in the column salestype. They are all null. I just want to change the datatype so I can begin adding data.