>SELECT firstname, lastname, address FROM DatabaseName WHERE firstname LIKE >"*keyword*" OR lastname LIKE "*keyword*" OR address LIKE "*keyword*"
I forgot to add an example of multiple keywords, but it's pretty straighttforward. SELECT recipename, ingredients, method FROM Recipes WHERE ingredients LIKE "*rice*" OR ingredients LIKE "*chili*" OR ingredients LIKE "*beef*" If you read the recordset into rows, you can then examine them and mark them (and sort them) according to how well they matched. 100% - chili con carne 33% - roast beef Regards, David ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
