match input parameter

Expand Post »

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

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.

Similar Threads

passing xml document as input parameter to web service in XML, XSLT and XPATH
How Input parameter insert in DB through Java Bean in JSP
Help needed with basic java methods in Java
How to Use an Input parameter in Stored Procedure with Datasets in C#
how to use an input parameter in where clause? in MySQL

Aussie_Here

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

18 posts
since Aug 2009

Permalink

Aug 29th, 2009

Re: match input parameter

Did you try using wild cards.

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

Last edited by cgyrob; Aug 29th, 2009 at 7:06 pm.

cgyrob

Reputation Points: 91

Solved Threads: 18

Junior Poster

Offline

125 posts
since Sep 2008

Permalink

Aug 30th, 2009

Re: match input parameter

Thanks a lot

Aussie_Here

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

18 posts
since Aug 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: date check constraint

Next Thread in MS SQL Forum Timeline: contains forms of inflectional

DaniWeb Message

Cancel Changes

User Name
Password