imran azam

imran azam

  • NA
  • 98
  • 12.3k

How to find value from comma seperate

Apr 6 2016 12:11 AM

Hi I am wondering how to write an SQL statement for SQL Server 2008 that Selects entry's where a column contains a value, now the value within the column is a comma delimited list (usually - there could only be one entry (and no leading comma)) for instance:

Column1

10-15,20-30,31-97,104-187

in this case i want to find 25.


Answers (3)