When I try to run this query: -

SELECT * FROM Staff WHERE ShowInList = 1 AND ShowInList2 = 1 ORDER BY Name ASC;

I get this error

3251: Object or provider is not capable of performing the requested operation

If I remove the ORDER BY part, I don't get any errors, so that's where I think the problem lies

The Name field is of VarChar type, but i have tried it as Char, NChar, NvarChar, Text and I can't get it to work.

any suggestions????