Hi,
I do not know what your problem is.
These two statements has allways worked exactly the same for me:
'DatabaseField' LIKE "XXX" + "%"
'DatabaseField' LIKE "XXX%"
If you are referencing field data with either 'field' or $field$, you have
to use the + sign. If you do it without a +, it would not work:
'DatabaseField' LIKE $Field$ + "%" (works)
'DatabaseField' LIKE $Field%$ (will give error on save)
So what are you having problems with???
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
