What is the best way to achive: I have a form with around 10(country, ssn,

Certified Senior Developer
What is the best way to achive:
I have a form with around 10(country, ssn, fname, lname, age, etc) search criteria fields. User is required to mandatorily enter only one field. Rest 9 are optional.
In this case, what would be the best implementation way?? I need to fetch the records from the DB(2 different tables) for the entered criteria. If I use Query Database, how my SQL looks like since the where clause is dependent on the user input.
Any guideline / document would be of great help.
TIA....

OriginalPostID-63845

OriginalPostID-63845

  Discussion posts and replies are publicly visible