[B,b]
On 10/11/06, Mike White <[EMAIL PROTECTED]> wrote:
No luck. I tried:
'Email Address' LIKE "[Bb]"
(note Email Address, Field ID 103 is not indexed for FTS and QBE match set
to Anywhere).
The example you provided is how I understand its usage - brackets within
the literal/quotes. I'm sure stumped getting it to work, though.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"David Sanders"
<[EMAIL PROTECTED] To: [email protected]
TING.CO.UK> cc:
Sent by: "Action Request Subject: Re: LIKE operator with brackets in search
System discussion
list(ARSList)"
<[email protected]>
10/11/2006 13:13
Please respond to arslist
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Ray Gellenbeck
[EMAIL PROTECTED]
"Momma always says there's an awful lot you could tell about a person by their shoes. Where they're going. Where they've been. I've worn lots of shoes." -- Forrest Gump __20060125_______________________This posting was submitted with HTML in it___
