I have a SQL Server database. One of the tables has a column that, for lack of a better word, is acting corrupted. I can select * or even select that specific column and it works fine. I can perform functions like count, order by and group by on all other columns with no problems. But if I try and do one of those functions on this one column, it errors out with the following message: Error: (State:S1000, Native Code: E28)
Also, I am connected to the database using winsql.
Has anyone ever seen this kind of behavior before?
Additional info:
select colname from tablename
works fine
select colname from tablename order by colname
produces the error