Hi Listers,

I'm still on ARS 6.3.

I need to make an AL that checks if a value of a char fields is made
of max. 8 digits.

I did this:

'fieldname' LIKE  "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]"

but this works only if I enter exact 8 digits...

Then I need to check if the value in the char field begins with E or
I, the second character is alphanumeric and the third character is a
"."
The lenght of the value doesn't matter in this case.

I'm trying:

('fieldname' LIKE  "E[A-Z].%")  OR ('fieldname' LIKE  "I[A-Z].%")

but it fails.


What am I missing here?

Thanks,
Mark

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Reply via email to