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 |
priyankas
Starting Member
2 Posts |
Posted - 2012-09-01 : 04:07:51
|
Hi all,Please help me for this,my records is like thatGroups2,3,41,2,3,5,73,7,81,4and if i am searching for 4 from the group column then below output should be displayGroups2,3,41,4Thanks in advancePri |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-01 : 04:17:27
|
[code]select *from tablewhere ',' + field + ',' LIKE '%,' + @value + ',%'[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
priyankas
Starting Member
2 Posts |
Posted - 2012-09-01 : 04:35:41
|
Thanks for thisPri |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-01 : 12:37:43
|
welcome ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|