Hi Gavin, Not sure I am right Second one will work. Since you are using this in filter and doing some operation which is on database level. Database only recognize operation like "%" and "_"
Regards Rajesh ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Coleman, Gavin Sent: Tuesday, November 16, 2010 6:13 PM 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<http://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"_ ________________________________ Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
