SELECT * FROM Customers WHERE ID in (SELECT ID FROM Customers WHERE Name like '%Pierre de blindage%' OR Desc like '%Pierre de blindage%' OR c1 like '%Pierre de blindage%' OR c2 like '%Pierre de blindage%' OR Details like '%Pierre de blindage%') ORDER BY Name ASC
THIS IS DB:C:\inetpub\vhosts\emotivemedia.com\httpdocs\ontario\on.mdb