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
