Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-30 : 08:24:35
|
| Ulysses Ponce writes "Hi, how to create Stored Procedure to pass a parameter in LIKE statement. Here the procedure I created.CREATE PROCEDURE uly_updte @cmpy char(5), @rver char(14) ASUPDATE tblpollSET flg = 'F'WHERE cmpy_cde = @cmpy AND flg = 'T' AND poll LIKE '%@rver%'problem in LIKE '%parameter%'Thanks,Uly" |
|
|
Nico
Starting Member
18 Posts |
Posted - 2002-08-30 : 09:29:22
|
| LIKE '%@rver%'should beLIKE '%' + @rver + '%' |
 |
|
|
|
|
|
LIKE Statement