Re: How to find records with length greater than 17
by "Plamen Ratchev" <Plamen@[EMAIL PROTECTED]
>
Apr 22, 2008 at 08:34 AM
There is no difference when you use LEN with Unicode column. If you need to
include the spaces you can use DATALENGTH. The only considerations is that
it returns number of bytes, so for NVARCHAR/NCHAR/NTEXT will return double
the length.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
