select CustomerName=FirstName+ ' ' + LastName from tbCustomer and result is Ramesh kumar gupta how to search :- Ramesh or kumar Or gupta or Remesh kumar or Remesh gupta or Kumar or gupta or kumar gupta
select * from tblCustomer where CustomerName like 'R%' or CustomerName like 'k%' or CustomerName like 'g%'
select * from table_name where Customer_name like '%CustomerName%'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)