Re: SQL STATEMENT

how about

    WHERE myfield like NVL(myinput,'%') or

    WHERE myfield = myinput or myfield IS NULL

Amy

In article <35e4b4d6.88482811_at_news.earthlink.net>,   beverett_at_remove_this.usa.net (Brian Everett) wrote:
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 28 1998 - 12:45:43 CDT