Quote:
Originally Posted by avsdude
Try :
comments is not null and comments <> ''
|
SELECT TOP 10
currentmodel,comments
FROM items
WHERE comments is not null and comments <> ''
I get this error: [Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.