I am using SQL CE 2.0 and have an ntext field which I need to sort. Due to integration issues, unfortunately ntext is all I am allowed to use. I am having difficulty sorting it though... when I use:
SELECT * FROM ...some table... ORDER BY ...something...
I get an error, and when I looked on the net, aparently ntext cant be sorted. Does anyone know of a solution to this...?