A critical error has occurred. The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

I am getting this error after installing and using Universal List on my site and playing with it a bit. The only thing that I changed that could even possibly make a difference was changing a numerical field's scale (decimal places) to 2. I don't think that's the problem. I deleted the instance of the module and uninstalled it and it's still giving me the error.

Anyone have any ideas what this is and how to fix it?

Problem solved. Yes, it was that column. I saved and it warned me that I could lose data changing from ntext to nvarchar(50) but since no categories are names longer than 50 characters, no problem. So a word of advice to Universal List customers... it's a really cool module, but you can easily screw something up. Be careful!