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 - 2000-11-06 : 14:29:46
|
Telly writes "I just read you statement on "Using the IN Notation in Stored Procedures" and was quite bothered by its simplicity and by its method. My main question to you is, Is what I am doing with CHARINDEX (below) not a good thing?
DECLARE @sINParam varchar(60)
SET @sINParam = ',1,2,3,4,5,6,7,8,9,'
SELECT
*
FROM
FOO
WHERE
CHARINDEX(',' + IdNo + ',',@sINParam) > 0" |
|
|
|
|
|
Using the IN Notation in Stored Procedures