Syntax problem

[vlitim]

I am using the below code but want to have the searchterm do:

name like '%@searchterm%'

but can't get the syntax to work

--Create a temporary table
CREATE TABLE #TempItems
(
ID int IDENTITY,
Name varchar(250),
PID int
)

-- Insert the rows from tblItems into the temp. table
INSERT INTO #TempItems (Name, pid)
SELECT Name,id FROM courses WHERE name = @searchterm ORDER BY name

 

[Tim1]

Hiya,

If you want to use the name like '%@searchterm%' then you need to have the % within the value @searchterm, so that you build it:

SELECT @searchterm = '%'
SELECT @searchterm = @searchterm + 'blah blah blah'
SELECT @searchterm = @searchterm + '%'

Then you can do

WHERE name LIKE @searchterm

That will work correctly

HTH

Tim

 

[vlitim]

Excellent, cheers for that!

 

[tlbroadbent]

You can also use the following syntax.

SELECT Name,id FROM courses
WHERE Name Like '%' + @searchterm + '%' Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost