Re: How to find records with length greater than 17
by "John Sheppard" <spam@[EMAIL PROTECTED]
>
Apr 22, 2008 at 04:23 PM
"Plamen Ratchev" <Plamen@[EMAIL PROTECTED]
> wrote in message
news:t9ednRsfVu9McZHVnZ2dnUVZ_jSdnZ2d@[EMAIL PROTECTED]
> The LEN function returns the number of characters excluding trailing
> blanks:
>
> SELECT namecol
> FROM Foo
> WHERE LEN(namecol) > 17;
>
> The DATALENGTH function returns the number of bytes.
>
> HTH,
>
> Plamen Ratchev
> http://www.SQLStudio.com
Wouldnt it matter if the field was in unicode then? What do you do if you
want to include the spaces?
I dont really want to know I just thought it weird that len would behave
like that...(Im an SQL server noob)
John Sheppard
