Filter Query Problem

Question

Name Code A 1001 B 1002 C 10011002 D 100110021003 when i serach 1001 only display A when i search 1002 only display B when I search 10011002 display ABC when i search 100110021003 display ABC D I want solution(query) for this problem.

Amit Gupta · Answer

Hey You can use your query by using like keyword Select * from tableName where code like '%1002%'

Bhimashankar Gangade · Answer

Manas Mohapatra i want different way not that way if any solution.

Manas Mohapatra · Answer

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/