Carey, Its perfect!!!
'Field' LIKE "%[^-0-9]%" worked like a charm! I feel like its my birthday already! ;) Huge thanks!!!!! Shawn Stonequist -----Original Message----- From: Carey Matthew Black [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 2:34 PM Subject: Re: Phone Numbers I think this Run if should get the job done. 'Field' LIKE "%[^-0-9]%" If you have to you might have to go as far as... 'Field' LIKE "%[^-0123456789]%" or maybe 'Field' LIKE "%[^0123456789-]%" ( I seem to remember the hyphen need to be first to be understood as not being a range, but I can not find that in the docs at the moment.) Read it as: When the field has a character that is not("^") a hyphen or in the range([0-9]) of "0 to 9". That just does not seem like that long of a Run If to me. :) JMHO: However I would push to not support the hyphen too. they are silly in a phone number. BTW: open and close parentheses are also silly. Phone _numbers_ are numbers... not formatting. That is for reports/display tools to do. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Feb 19, 2008 2:01 PM, Shawn Stonequist <[EMAIL PROTECTED]> wrote: > Greetings List! > > This may be a bit strange. We have a form that is used & populated by > one of our customers. The data is sent electronically to third company. > Unfortunately, "strange" characters are being entered into the Phone > Number fields, which is causing an issue. The customer is requesting > an error message (not a replacement) when anything other than a digit > or a hyphen is entered. > > Does anyone know of a way to do this (other than an extremely long Run > If qualification that lists every letter and symbol)? > > Huge thanks! > Shawn Stonequist > EMNS, Inc. > Remedy 6.3 ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
