Guest_imported
New member
- Jan 1, 1970
- 0
Hi, how can I handle a search criteria that consist of more than one fields that I may or may not populate for me to search the database? I'm trying to avoid a huge case statement.
Ex:
My Search Criteria: Column A, B, C, D
Now I may enter 1 for Column A, nothing for B, 2 and 3 for C and D respectively.
Should I create a temp table and join it into my where clause?
Thanks.
Ex:
My Search Criteria: Column A, B, C, D
Now I may enter 1 for Column A, nothing for B, 2 and 3 for C and D respectively.
Should I create a temp table and join it into my where clause?
Thanks.
