SQL search query needed for delphi form with 3 search fields
Posted on 2010-09-15
I have a delphi form with 3 search fields.
First Name, Last Name, City
I want to allow the user to search either 1 field (which the query is very simple) but I am having difficulties if the user enters in 2 or more criteria. Because of the OR in the statement, when user searches for 'John' in First Name and 'Oakland' in City, it returns all records where John is first name, oakland is city AND Last Name is blank. How can I allow users to search for 1, 2 or all 3? Do I have to state every possible search combination?