How to find value from comma seperate

For example :

I have two table Table1(Column1,Cloumn2) and Table2 These data 10-15,20-30,31-97,104-187

are coming from Table1 and sitting in Table2 as a comma seperated.

eg; value 20-30 means (Exist all value between 20 and 30) 20 from Column1 and 30 from Column2. These value i am storing in table2 as Comma seperated. You can see yesterday i asked how to save two column data in comma seperated with screen shot and i got answer.

Shubham Kumar10y ago

Hi, Imarn just use split function of sql take a look of this link http://stackoverflow.com/questions/10914576/t-sql-split-string

Manas Mohapatra10y ago

In above question you want to find 25 but it is not present in your column value. Please provide a valid example what you need exactly..