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"
<[email protected]> 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:[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<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"
