Posted by Erland Sommarskog on 12/14/06 22:36

Matik (marzec@sauron.xo.pl) writes:
> Roy Harvey napisal(a):
>> WHERE LEN(ClaimNumber) = 8
>>
>> or possibly you will need
>>
>> WHERE LEN(RTRIM(ClaimNumber)) = 8
>
> .... or in case N data, and automaticly avoid problem with spaces:
>
> where datalength(ClaimNumber)/2 = 8

Not really sure what you mean. len() counts characters and ignores
trailing spaces, so it is an ideal function to use in this case, as
it works the same with varchar and nvarchar data. (It does not work
with text/ntext though.)

datalength on the other hand counts bytes and includes trailing spaces,
so with datalength you need to trim and you need to know whether you
are working with varchar or nvarchar data.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]