Compare comma separated value in comma separated column in sql server with different sequence

Question

I have column in my table that contains the values like that:

1,3,4,2,6,5

I want to check all the values in the above column..

how to do it??

I want to run the query like ths:

select * from table where column contains 1,2,3,4,5,6

I tried to use like operator but it does not work if column has without sequence values..

You should fix your data model and stop storing comma delimited values. — , Nov 18 '13 at 11:04
user2003615 - please demonstrate some respect. People here are doing you a favour. — Raj, Nov 18 '13 at 11:07
It means - "Use your brain to just answer the question asked. There is no need to be overly smart". I apologize on his behalf. — Raj, Nov 18 '13 at 11:11
http://stackoverflow.com/questions/18744391/t-sql-how-to-convert-comma-separated-string-of-numbers-to-integer — Raj, Nov 18 '13 at 11:16

score 0 · Answer 1 · answered Nov 18 '13 at 13:26

0

That's not very efficient, but will do:

select 
    * 
from [table]
where ','+ '1,2,3,4,5,6' +',' like '%,'+ cast(column as varchar(255)) +',%'

answered Nov 18 '13 at 13:26

AdamL

1 Answers1