Friday, May 6, 2011

select records with comma

use full query for searching records base on , request

select * from msttest WHERE ',' + testfield1 + ',' LIKE '%,11,%' or testfield1 in('11','12')

No comments:

Post a Comment