```
Id  vDivisionNo
1    1,9
2    9
3    1
4    9,1

```

i have using char index but not find value 

```
select * from DivisionMst where CHARINDEX(',' + vLocationNo + ',', ','+ '9,14' + ',') > 0  

```

And Try this

```
select * from DivisionMst where CHARINDEX(',' + '9,14' + ',', ','+ vLocationNo + ',') > 0

```

But Not working please help me.