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"
