I have a database with 14 tables each table containing the same amount of fields. I mistakenly made 1 field a datatime type and would like to change it to a straight date type or varchar type. I am getting this error message when I perform my query.
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
How can I change this type or work around it.