I agree with Dwayne. I don't know if it has something to do with how Remedy parses out the variable or not, but I've found that sometimes I have to use LIKE ($Company$ + "%") in cases where I'm using a variable within a filter.
Thanks, Gary Opela, Jr. Remedy Engineer Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Martin, Dwayne - martinrd Sent: Tuesday, November 16, 2010 7:51 AM To: [email protected] Subject: Re: LIKE Query ** Hi Gavin, I am curious as to which one works. I've only heard of using the "+" sign with a variable, eg. 'LIKE $Company$ + "%"', but it seems like 'LIKE "Company" + "%"' should work too. Dwayne Martin James Madison University From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Coleman, Gavin Sent: Tuesday, November 16, 2010 7:43 AM To: [email protected] Subject: LIKE Query ** Hi List - we've got an interesting problem here. What is the difference between the following: LIKE "Company" + "%" LIKE "Company%" I would have assumed nothing, but one of these works and one doesn't. Is there anybody that can explain the difference? I've run across this before, but never really wanted to find out WHY it worked / didn't work. The above qualification occurs in a Filter Run If statement. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: [email protected] <mailto:[email protected]> W: www.computacenter.com ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
