Re: How to find records with length greater than 17
by ciojr@[EMAIL PROTECTED]
Apr 22, 2008 at 09:15 AM
On Apr 21, 3:36=A0pm, "Plamen Ratchev" <Pla...@[EMAIL PROTECTED]
> wrote:
> The LEN function returns the number of characters excluding trailing
blank=
s:
>
> SELECT namecol
> FROM Foo
> WHERE LEN(namecol) >17;
>
> The DATALENGTH function returns the number of bytes.
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com
Right - i dont want to include spaces.
I want to check where the first word is greater than 17
