|
Graham, I just now got a chance to read your reply. After reading some of the other posts I wonder if we are talking about two different usages. I am thinking of coding the wildcard directly into the statement such as SELECT * FROM CUSTOMER WHERE NAME LIKE 'Ric%'. Are you referring to this usage or substituting the like in the form of a variable such as SELECT * FROM CUSTOMER WHERE NAME LIKE :substring? I don't believe I have used the wildcards as part of a substitution variable before. Always a hard coded part of the statement or else when using interactive SQL. I wonder if it behaves differently between for each use? Rick -----Original Message----- From: Smith, Graham [mailto:GSmith2@scj.com] Sent: Thursday, January 02, 2003 11:53 AM To: 'midrange-l@midrange.com' Subject: RE: SQL Question Rick, I wish you were right but I've bitter experience behind me in this case. Stumbled across this years back and found that in a Host variable the single % didn't work correctly but padding full length of host variable worked fine. Go figure! Cheers Graham
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.