Simple question how to test a strings composition

[justagrunt]

Hi,
Brain dead question but I've never considered it before.
How do you test a string for is makeup.
If I want to test a string to see if it contains 4 digits format like "1234" or test a string if it has 2 alpha and 4 digits like "JN1234" or even if the string is long and made of alpha numerics like text.
Kind Regards.

 

[mikevh]

The LIKE operator is a good place to start.

4 digits =
LIKE "####"

2 alpha's followed by 4 numerics =
LIKE "[A-Z][A-Z]####"

That may be all you need. If you need something
fancier, there are regular expressions.
See thread222-487214

 

[justagrunt]

Hi,
Just The ticket.
Thanks