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