Return rows where column is less than 10 characters

[rjl444@hotmail.com]

I need a query to simply return rows where a column has less than 10
characters (nvar).
thanks.
rjl

[Gregory Dean]

Re: Return rows where column is less than 10 characters

On 2/3/05 11:10 AM, in article
1107447015.0444 64.301660@g14g2 00...legr oups.com, "rjl444@hotmail .com"
<rjl444@hotmail .com> wrote:
[color=blue]
> I need a query to simply return rows where a column has less than 10
> characters (nvar).
> thanks.
> rjl
>[/color]

SELECT * FROM theTable WHERE LEN(theCol) < 10

[rjl444@hotmail.com]

Re: Return rows where column is less than 10 characters

Thanks alot Gregory!


Gregory Dean wrote:[color=blue]
> On 2/3/05 11:10 AM, in article
> 1107447015.0444 64.301660@g14g2 00...legr oups.com,[/color]
"rjl444@hotmail .com"[color=blue]
> <rjl444@hotmail .com> wrote:
>[color=green]
> > I need a query to simply return rows where a column has less than[/color][/color]
10[color=blue][color=green]
> > characters (nvar).
> > thanks.
> > rjl
> >[/color]
>
> SELECT * FROM theTable WHERE LEN(theCol) < 10[/color]