Stored Procedures with Passed Variables 1

[ljevans]

I have a stored procedure that uses a "Like..." statement. It works fine if I hard code a value into it, but as soon as I pass a variable to it, it returns 0 records. It looks something like this

CREATE PROCEDURE getJobs
@job varchar(4)
AS 
SELECT item1, item2
FROM myTable
WHERE jobNumber Like '%@job%'

The data is stored as a varchar in the database and again, if I hard code a value into the statement, it returns 12 records.

Thanks

 

[tlbroadbent]

Change Select statement in the SP to this.

SELECT item1, item2
FROM myTable
WHERE jobNumber Like '%' + @job + '%'
Terry

;-) "When I hear somebody sigh, 'life is hard', I am always tempted to ask, 'compared to what'?" - Sydney Harris

 

[KevinFSI]

Thanks!!! That worked like a charm.

I'm the same person who wrote the original post. I was just using a co-worker's computer at the time.

Thanks again for the help. Kevin
slanek@ssd.fsi.com