Hi Mike Here's an example of its usage in a run-if:
'zzTemp1' LIKE "[0-9]" Notice that you DO NOT need the wildcard operator. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Wednesday, October 11, 2006 6:07 PM To: [email protected] Subject: Re: LIKE operator with brackets in search Yes - I know I can expand the search with an OR to search for both conditions. I'm trying to understand how to use the brackets. It's an advertised feature. Is there a problem with it? I'm still researching on-line documentation... Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "Grooms, Frederick W" To: [email protected] <frederick.w.groo cc: [EMAIL PROTECTED]> Subject: Re: LIKE operator with brackets in search Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 10/11/2006 11:34 Please respond to arslist I think that is correct. Just to be safe why don't you just do the or in your search (and not worry about the brackets): (('Email Address' LIKE "B0%") OR ('Email Address' LIKE "b0%")) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Wednesday, October 11, 2006 10:12 AM To: [email protected] Subject: LIKE operator with brackets in search Listers, I've never fiddled with searches that use a combination of LIKE operator and brackets (i.e. [ and ]). Have read the documentation and believe I'm using it correctly, but it's not returning any matching requests. My customer is changing their e-mail server and e-mail address format, so I'm trying to identify users whose e-mail address is in the old format. I'd previously implemented a maintenance facility so they can update their own, so I have a mix of upper and lower case entries. I'm looking for e-mail addresses that begin with B0 or b0, so in a User search window, I tried the following in ASB: 'Email Address' LIKE "[Bb]0%" If I use 'Email Address' LIKE "B0%" or 'Email Address' LIKE "b0%", each returns matching requests. Am I using this incorrectly (brackets or LIKE)? We're running ARS 6.0.1, patch 1454, on Oracle 9i and Solaris 5.9 Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
