Need help with stored procedure. - 03-13-2005 , 09:25 PM
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.
Re: Need help with stored procedure. - 03-14-2005 , 11:20 AM
Asked and answered in .clients, .programming, .notificationsvcs.
Please refrain from multiposting.
SQL Server MVP
"Vanessa Lee" <van77788 (AT) yahoo (DOT) com> wrote