That doesn't look right to me. That looks like it would match text that contains at least one character that is NOT a number. Meaning that any of these would match that expression: foo, f00, 0a0, etc. 123 would NOT match that expression. 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]%" Lyle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mark Milke Sent: Tuesday, February 02, 2010 8:44 AM To: [email protected] Subject: How to allow a specific character as first character? Hi there, I have a character field that I need to convert into an integer field or to emulate a field that accepts positive and negative numbers only. This: 'Field1' LIKE "%[^0-9]%" works just fine to enforce numbers only. But how to enforce, that an input consists of numbers only and *can* start with a "-" (emulation of negative numbers)? Thanks, Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
