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

[Back to original message]