SQL STATEMENT

  Greetings All.

     I have a table of zip codes and a web form that attempts to query the table based on three fields on the form. The user can provide as little or as much information in these three fields as they would like. Problem: I do not know in advance which fields will be entered. How do I structure the select statement (cursor (Oracle)) so that fields not entered will not restrict the returned records but field which are entered will restrict the output. I've tried a number of approaches and some work well but not in every scenario. Since there are three fields then there are 8 possible ways inputs can be anticipated. I hope I haven't confused anyone. I used to do something in Access like this...

   ...where myfield = myinput or myfield is null;

Oracle needs something else it would appear.

Thanks
Brian

Good Luck! Brian_RestonVA Received on Wed Aug 26 1998 - 20:38:04 CDT