What database are you on? If I recollect right, MS-SQL was picky between LIKE “Company” + “%” ***and*** LIKE “Company%”.
It used to not like LIKE “Company%” On Oracle and the later versions of MS-SQL, both should return consistent results.. Joe From: Coleman, Gavin Sent: Tuesday, November 16, 2010 7:43 AM Newsgroups: public.remedy.arsystem.general 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] 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 ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
