MS SQL

match input parameter

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Aug 2009

Posts: 10

Reputation: Aussie_Here is an unknown quantity at this point

Solved Threads: 0

Aussie_Here Aussie_Here is offline

Offline

Newbie Poster

match input parameter

Aug 29th, 2009

I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM Table1
WHERE Name LIKE @Name
Select * from Table1
Where Name LIKE @Name

but it didnt work. Can you help plz?

Last edited by peter_budo; Sep 7th, 2009 at 12:43 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Sep 2008

Posts: 123

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Re: match input parameter

Aug 29th, 2009

Did you try using wild cards.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM Table1
WHERE Name LIKE ('%' + @Name + '%')
Select * from Table1
Where Name LIKE ('%' + @Name + '%')