LIKE %?

[RJ5]

Hello again.

I'm having difficulty with the LIKE condition.

e.g.

CREATE PROCEDURE sp_NAME
@lastname varchar(10)
AS
SELECT * FROM tbl1 WHERE wholename like %@lastname%

How do I use a variable in a LIKE condition? I'm going to execute the SP in VB6.

Thanks for any suggestion

Randy : )

 

[Cagliostro]

try something as

SELECT * FROM tbl1 WHERE wholename like '%' + '@lastname' + '%'
John Fill

ivfmd@mail.md

 

[RJ5]

many thanks john.

stay cool.

 

[tlbroadbent]

I think you'll find this works.

SELECT * FROM tbl1 WHERE wholename like '%' + @lastname + '%'
Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes