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"