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
