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
