len(variable) for sql?

[djc]

I know that vb has the len() function that will return the number of
characters in a string. Does T-SQL have an equivelent for querying fields?
For example, I would like to write a query that returns the number of
records who's password field is < 7 characters?

can I?

[Ray at]

Yes, it's called LEN. :] Do you have the SQL Server Books Online?

select something from somewhere where len(something) < 7

Ray at work

"djc" <noone@nowhere.com> wrote in message
news:%23CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

> I know that vb has the len() function that will return the number of
> characters in a string. Does T-SQL have an equivelent for querying fields?
> For example, I would like to write a query that returns the number of
> records who's password field is < 7 characters?
>
> can I?
>
>

[djc]

thanks ray. re: server books online... got the hint.

: )

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:OoXl6OlmDHA.2216@TK2MSFTNGP12.phx.gbl...

> Yes, it's called LEN. :] Do you have the SQL Server Books Online?
>
> select something from somewhere where len(something) < 7
>
> Ray at work
>
> "djc" <noone@nowhere.com> wrote in message
> news:%23CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

> > I know that vb has the len() function that will return the number of
> > characters in a string. Does T-SQL have an equivelent for querying

fields?

> > For example, I would like to write a query that returns the number of
> > records who's password field is < 7 characters?
> >
> > can I?
> >
> >

>
>

[Aaron Bertrand [MVP]]

DATALENGTH()

(Advantage over LEN() is that it also works for text, ntext, etc.)





"djc" <noone@nowhere.com> wrote in message
news:#CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

> I know that vb has the len() function that will return the number of
> characters in a string. Does T-SQL have an equivelent for querying fields?
> For example, I would like to write a query that returns the number of
> records who's password field is < 7 characters?
>
> can I?
>
>

[Harag]

doesn't DATALENGTH() return the number of bytes not the number of
characters?

eg:

DECLARE @chvnText NVARCHAR(30)
SET @chvnText = N'text'

PRINT DATALENGTH(@chvnText)

returns 8 not 4

(unless you use VARCHAR and not NVARCHAR)

HTH

Al.



On Sun, 26 Oct 2003 10:18:55 -0500, "Aaron Bertrand [MVP]"
<aaron@TRASHaspfaq.com> wrote:

>DATALENGTH()
>
>(Advantage over LEN() is that it also works for text, ntext, etc.)
>
>
>
>
>
>"djc" <noone@nowhere.com> wrote in message
>news:#CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

>> I know that vb has the len() function that will return the number of
>> characters in a string. Does T-SQL have an equivelent for querying fields?
>> For example, I would like to write a query that returns the number of
>> records who's password field is < 7 characters?
>>
>> can I?
>>
>>

>

[Aaron Bertrand [MVP]]

Yes, if it's ntext or nchar or nvarchar, you'd divide by 2. Still more
useful than len.



"Harag" <harag@softGETRIDOFCAPLETTERShome.net> wrote in message
news:bdgopvc9d17lavkhlrs22b10i75ucdpij3@4ax.com...

>
> doesn't DATALENGTH() return the number of bytes not the number of
> characters?
>
> eg:
>
> DECLARE @chvnText NVARCHAR(30)
> SET @chvnText = N'text'
>
> PRINT DATALENGTH(@chvnText)
>
> returns 8 not 4
>
> (unless you use VARCHAR and not NVARCHAR)
>
> HTH
>
> Al.
>
>
>
> On Sun, 26 Oct 2003 10:18:55 -0500, "Aaron Bertrand [MVP]"
> <aaron@TRASHaspfaq.com> wrote:
>

> >DATALENGTH()
> >
> >(Advantage over LEN() is that it also works for text, ntext, etc.)
> >
> >
> >
> >
> >
> >"djc" <noone@nowhere.com> wrote in message
> >news:#CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

> >> I know that vb has the len() function that will return the number of
> >> characters in a string. Does T-SQL have an equivelent for querying

fields?

> >> For example, I would like to write a query that returns the number of
> >> records who's password field is < 7 characters?
> >>
> >> can I?
> >>
> >>

> >

>

[djc]

Thanks!

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:uyPC6R9mDHA.2216@TK2MSFTNGP12.phx.gbl...

> DATALENGTH()
>
> (Advantage over LEN() is that it also works for text, ntext, etc.)
>
>
>
>
>
> "djc" <noone@nowhere.com> wrote in message
> news:#CaPaNlmDHA.3320@tk2msftngp13.phx.gbl...

> > I know that vb has the len() function that will return the number of
> > characters in a string. Does T-SQL have an equivelent for querying

fields?

> > For example, I would like to write a query that returns the number of
> > records who's password field is < 7 characters?
> >
> > can I?
> >
> >

>
>