returning string length

[William Kossack]

I need to write a query that tells me which string values are empty or
blank in a table.

Is it possible to return the length of the string contained in character
field?

[Mike Epprecht \(SQL MVP\)]

Look at the LEN function.
If you need to determine if it is null, use IS NULL to evaluate it.

Regards
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"William Kossack" <ko******@njc.org> wrote in message
news:10*************@corp.supernews.com...

I need to write a query that tells me which string values are empty or
blank in a table.

Is it possible to return the length of the string contained in character
field?

[Ryan]

Or DataLength

[Erland Sommarskog]

Ryan (ry********@hotmail.com) writes:

Or DataLength

There are a couple of differences between len() and datalength()

o len() gives the length in charcters, datalength() in bytes (which
matters for nchar/nvarchar).
o len() excludes trailing blanks, datalength does not.
o datalength() is the only one to work on text/ntext/image.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp