/* try to find out in this way */ /* CandidateDetails.LastName like '%" + SearchByName + "%' "; there should not be any space between '%YourWord %' because it considered space also */ /* i have tried this and working Properly May be There is some Other Error */ insert into test1 values('AT&T') select Name from test1 where Name like'%AT&T%' select Name from test1 where Name like '%at&t%' Name --------------------------- AT&T (1 row(s) affected) Name --------------------------- AT&T (1 row(s) affected)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)