Okay well what's the actual length of the data?
From enterprise manager, try this :
SELECT *
FROM tblProducts
WHERE (LEN(strDescription) > 100)

(that works for me on my database, change the table name and the field name)