Posted by TGEAR on 12/13/06 20:55

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?

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

[Reply to this message]