Theoretically there is not supposed to be a difference in result because the + operator is supposed to perform the concatenation for you. Whether or not the concatenation occurs properly or not, however, is an unknown.
Performance wise, "%ABC" is probably a smidgeon faster because the concatenation function does not have to execute. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chintan Shah Sent: Thursday, September 20, 2007 11:10 AM To: [email protected] Subject: Difference between LIKE ( "%" + "ABC") and LIKE ("%ABC") ** Hello all, I am in middle of digging an issue and I think the above thing can be an issue..but just wanted to get inputs from all of you. Thanks in advance Regards, Chintan. ________________________________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. <http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhos ting/?p=PASSPORTPLUS> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
