Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2014-08-27 : 08:35:28
|
| Hi All,I have data in below format in table1 col1 1234,3456,12345,4567,4567,5677,4567,123Now I want to search a value "1234" in above table I can not use like operator her as it will return 123 alsoPlease suggest |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-27 : 08:41:09
|
| [code]like '1234,%'[/code] |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-08-27 : 08:42:02
|
| [code]','+col1+',' LIKE '%,1234,%'[/code] |
|
|
|
|
|
|
Select Query