[Solved] How get data in split string data for SQL Server [closed]

Question

And yet another variant

SELECT * FROM [table] WHERE ','+[data]+',' LIKE '%,E55555,%'

The problem though, is that what you are asking for won’t be able to use normal indexes, which means an inefficient table scan every time you query. You may want to consider breaking the comma delimited values into their own columns so you can query on them efficiently. As it is you have a ‘super’ column that crams multiple pieces of data into a single column.

Accepted Answer

And yet another variant

SELECT * FROM [table] WHERE ','+[data]+',' LIKE '%,E55555,%'

The problem though, is that what you are asking for won’t be able to use normal indexes, which means an inefficient table scan every time you query. You may want to consider breaking the comma delimited values into their own columns so you can query on them efficiently. As it is you have a ‘super’ column that crams multiple pieces of data into a single column.