Re: conditional selection of 'AND'

rohit_reborn_at_yahoo.com (Rohit Dhawan) wrote in message news:<c76d1c78.0404171636.3306306f_at_posting.google.com>...
> I have one query similar to the following:-
>
> select coursenum,sectionnum,instructor from
> SECTION s where (sectionnum = '001')
> and coursenum LIKE 'MATH%'
>
>
> but is it possible to add another 'and' condition to the above query
> provided a certain user parameter = 'add'
>
> for e.g
>
> select coursenum,sectionnum,instructor from
> SECTION s where (sectionnum = '001')
> and coursenum LIKE 'MATH%'
> and instructor LIKE 'L%' i.e. only and only if :parameter = 'add' else
> the above query gets executed.
>
> I do not want to use procedure for the above as I think everyting can
> be done using and,or,not

decode?

jg

--
@home.com is bogus.
http://ask.slashdot.org/article.pl?sid=04/04/16/1954234