Hi,
Are you really sure about that???
I is easy to try out using Advanced Search. I would be surprised if there
were any difference...
I just tried it on my ARServer 7.6.03 with SQL Server 2008 R2, and both
version gave te same result.
If you write an ACTL/FLTR Set-Fields with the following query:
('Company' LIKE $Company$ + "%")
It will be converted to something like:
SELECT C1,C8 FROM T99 WHERE C536870913 LIKE 'RRR' + '%'
>From what I know about SQL, both of these should work the same:
... WHERE C536870913 LIKE 'RRR' + '%'
... WHERE C536870913 LIKE 'RRR%'
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.
> 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: 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
>
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
