I have a table in a database that has a column defined as varchar 12. I attempted to use the sum function in isql and it failed.
Server: Msg 409, Level 16, State 2, Line 2
The sum or average aggregate operation cannot take a varchar data type as an argument.
Does this have to be INT or something else? Is it possible to change the column now that it has been created and populated? It only has numbers in it. How can I go about getting around this?