|
|
Posted by Roy Harvey on 12/13/06 21:01
WHERE LEN(ClaimNumber) = 8
or possibly you will need
WHERE LEN(RTRIM(ClaimNumber)) = 8
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 12:55:20 -0800, "TGEAR" <ted_gear@hotmail.com> wrote:
>Claim number (string)
>CF060001
>CF060001A
>CF060001B
>AV000001
>AV000212F
>AV000001F
>FD232122
>FD232122G
>SD223213
>SD223213H
>
>I only want to get records, which have length of 8 characters.
>So output will be CF060001, AV000001, FD232122, and SD223213
>
>Anyone can help me to write this in sql?
Navigation:
[Reply to this message]
|