Lyle, >That said, if your approach is to match the opposite and negate it, then that >might work. >If so, then you might be able to do it like this:
> 'Field1' LIKE "%[^0-9]%" OR 'Field1' LIKE "[^-]%[^0-9]%" Yes, I want to match the opposite to show an error message. The suggested qualification isn't working however. The qualification 'Field1' LIKE "%[^0-9]%" OR 'Field1' LIKE "[^-]% [^0-9]%" works just fine to prevent users from entering alpha characters. Unfortunately it also prevents strings like -2222 for some reason... The qualification 'Field 1' LIKE "[^-]%" AND 'Field 1' LIKE "% [^0-9]%" is very close to what I'm looking for, but it allows input like -m000 for some reason. @Misi I'm don't want to use patterns, because they generate a very user unfriendly error messages. I'm trying to avoid specyfing all possiblities. If the wildcards work as documented, then it should be possible to tackle the problem without it. Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
