Re: How to find records with length greater than 17

ciojr@[EMAIL PROTECTED]
 wrote:
> 
> On Apr 21, 3:36 pm, "Plamen Ratchev" <Pla...@[EMAIL PROTECTED]
> wrote:
> > 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 Ratchevhttp://www.SQLStudio.com
> 
> Right - i dont want to include spaces.
> I want to check where the first word is greater than 17

It won't do that. For example, the query above will also select the row
where namecol has a value of 'John Smithersonson'

So if Plamen's solution does not do what you want, then please some
example data and desired output.

-- 
Gert-Jan