RE: SQL Question

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

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