SELECT distinct(a.customerid),a.*,b.* from nop_customer a,nop_customerattribute b where a.customerid = b.customerid and a.email like @Value + '%' or a.username like @Value + '%' or (b.[key] like 'FirstName' and b.value like @Value + '%')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)