Hi,
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.
Vanessa

Asked and answered in .clients, .programming, .notificationsvcs.

Please refrain from multiposting.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--


"Vanessa Lee" <van77788 (AT) yahoo (DOT) com> wrote