RE: Need help with stored procedure.
From: marcmc (marcmc_at_discussions.microsoft.com)
Date: Mon, 14 Mar 2005 03:17:03 -0800
There a a number of ways to do this, here are two.
SELECT * FROM table1 WHERE @String like '%word3%'
SELECT * FROM table1 WHERE @String = 'word3'
"Vanessa Lee" wrote:
> I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
> @String = 'word1word2word3word4word5' - This value is passed to Stored
> Procedure from the script.
> Column1 in a table1 has many rows with "words" . One row in this column1
> will have 'word3'. Notice that this 'word3' is contained in the @String.
> I need to write a stored procedure SELECT statement that will return all
> (Select *) values from all columns corresponding to a row containing
> 'word3'. (this 'word3' must be found in @String). 'word3' is the entire
> value of the column. Somehow the search will have to be done on @String to
> see if there is a match, and if there is a match, return values of all
> columns corresponding to this row where the match is found.
> It will have to be something like:
> SELECT * FROM table1 WHERE @String has 'word3' in it.
> I need help with the statement after the WHERE command.
> Thank you for your help.