Results 1 to 3 of 3
Thread: Simple stored procedure question
Nov 6, 2009, 05:13 #1
- Join Date
- Sep 2005
- Puerto de Mazarron, Murcia, Spain
- 0 Post(s)
- 0 Thread(s)
Simple stored procedure question
I am trying to write a stored procedure that searches for text and not sure how to put a wild card either side.
Can someone help please.
ALTER PROCEDURE [wneedham].[adfero_article_search] @search_text VARCHAR(255) = NULL AS BEGIN SELECT * FROM adfero_articles WHERE contents LIKE '%@search_text%' ORDER BY created DESC END