In the later versions of the SQL server this was no longer an issue.. I
don't recall the version where it used to be an issue.. Maybe it was as old
as MS-SQL 6.5..
Joe
-----Original Message-----
From: Misi Mladoniczky
Sent: Wednesday, November 17, 2010 2:11 AM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: LIKE Query
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: [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"
