I have found that it seems that when I use LIKE "Company%", the % is not used a wild card but as the actual per cent symbol in the search.
So when in doubt I use LIKE "Company" + "%" Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of pritch Sent: Tuesday, November 16, 2010 9:09 AM To: arslist@ARSLIST.ORG Subject: Re: LIKE Query I usually use the second so that's probably the one that works. Could be a precedence issue; try putting the "Company"+"%" in parenthesis ("Company"+"%"). On Tue, 16 Nov 2010 13:50:41 +0000, "Martin, Dwayne - martinrd" <marti...@jmu.edu> wrote: > 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:arsl...@arslist.org] On Behalf Of Coleman, Gavin > Sent: Tuesday, November 16, 2010 7:43 AM > To: arslist@ARSLIST.ORG > 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: gavin.cole...@computacenter.com<mailto:gavin.cole...@computacenter.com> > 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"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
