I have a requirement.
Given say Test1,Test2, I have to perform a like operation.
Something like
select * from tblname where column_name like('Test1%','Test2%');
i.e. these strings are comma separated
How do I solve this?
This is in SQL SERVER 2005.
Thanks in Advance
Sql server 2005, try this
You will need to create a TSQL statement like this:
You need an OR for each case
Sample code :