SELECT propertyID FROM properties WHERE LEN(propertyDescription) > 200
gives me the result
Server: Msg 8116, Level 16, State 2, Line 1
Argument data type ntext is invalid for argument 1 of len function.
So maybe I can't len ntext fields?
Any one know of a work around?