Wildcard question

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

Re: Wildcard question

-Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: 19 February 2009 16:05 To: arslist@ARSLIST.ORG Subject: Wildcard question Hi Listers, I'm still on ARS 6.3. I need to make an AL that checks if a value of a char fields

Re: Wildcard question

** Mark, the only thing I would add to Brian's email is first make UPPER function to make sure the alpha values are in upper case and then to check for the upper case "E" or "I" add it to his replace. Or do do your wildcard with "[EI]". Hope this helps Rocky Rocky Rockwell

Re: Wildcard question

: Thursday, February 19, 2009 3:32 PM To: arslist@ARSLIST.ORG Subject: Re: Wildcard question ** Mark, the only thing I would add to Brian's email is first make UPPER function to make sure the alpha values are in upper case and then to check for the upper case E or I add it to his replace. Or do do