How to change IN operator with CHARINDEX within the WHERE clause SQL

Asked Apr 12 '16 at 08:08

Active Apr 12 '16 at 08:09

Viewed 14 times

I have these query :

SELECT *
FROM   
    Table_a A
    JOIN Table_b B
        ON (B.ID = A.ID)
WHERE
    (A.UserLogin = @UserLogin)
    AND (B.ID IN @DocumentID)

And I want to change using Charindex :

SELECT *
FROM   
    Table_a A
    JOIN Table_b B
        ON (B.ID = A.ID)
WHERE
    (A.UserLogin = @UserLogin)
    AND CHARINDEX(@DocumentID, B.ID ) > 0)

But the value of @DocumentID='3,4,5'. I don't know how to use CHARINDEX in this case. Can someone help... Thanks

edited Apr 12 '16 at 08:09

Mitch Wheat

295,962
43
465
541

asked Apr 12 '16 at 08:08

starter_id

[Parameterize an SQL IN clause](http://stackoverflow.com/questions/337704/parameterize-an-sql-in-clause) – Lukasz Szozda Apr 12 '16 at 08:10
1

Do it right, use table-valued parameter. – Lukasz Szozda Apr 12 '16 at 08:10
@lad2025 I don't think so. I think I need to make little change in the CHARINDEX statement. But I don't know how... – starter_id Apr 12 '16 at 08:17
So, the CHARINDEX can accept more than 1 value of @DocumentID. – starter_id Apr 12 '16 at 08:18
http://stackoverflow.com/a/13534053/5070879 with `CHARINDEX` version and [demo](http://sqlfiddle.com/#!3/31994/3) – Lukasz Szozda Apr 12 '16 at 08:22

How to change IN operator with CHARINDEX within the WHERE clause SQL

0 Answers0