Posted by Matik on 12/14/06 17:15

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

Matik

• Next in forum: Re: Inner Join Problem
• Prev in forum: Re: How to match records on several substring functions
• Thread view: Re: getting length of 8 characters

[Reply to this message]