Loading

Filter Query Problem

Bhimashankar Gangade

when i serach 1001 only display A

when i search 1002 only display B

when I search 1001,1002 display A,B,C

when i search 1001,1002,1003 display A,B,C D

I want solution(query) for this problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Hey

You can use your query by using like keyword
Select * from tableName where code like '%1002%'
Bhimashankar Gangade9y ago
Manas Mohapatra i want different way not that way if any solution.
Manas Mohapatra9y ago
You can follow below link:

https://www.codeproject.com/Tips/1101816/How-to-Query-Comma-Seperated-Value-Column-in-SQL

https://blog.sqlauthority.com/2015/04/21/sql-server-split-comma-separated-list-without-using-a-function/