View Single Post
Old 11-12-2004, 11:07 AM   #3 (permalink)
Lord Humungus
Addict
 
Lord Humungus's Avatar
 
Location: The Outer rim of HELL
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.
__________________
I am still searching for the movie this quote was in...
"Make you strong, like bull", said in a russian accent
Post here if you know anything...PLEASE!
Lord Humungus is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73