I have a search page with the following query that will return an exact match for a surname. How do I adjust this query to allow for a check box, than when checked will return Soundex values. If it is left unchecked it returns an exact match. (i.e. this code returns all Snyders -- "Select Surname FROM database WHERE Soundex(Surname) = Soundex('Snider');"
Of course I want the user to be able to enter any surname, not just Snider!