Rohit Dhawan wrote:
> 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 (first)query gets executed.
>
> I do not want to use procedure for the above as I think everyting can
> be done using and,or,not
HOW?
SQL language does NOT provide any type of conditional statement
such as IF, THEN, ELSE
Received on Sat Apr 17 2004 - 20:13:21 CDT
