Subject | RE: [firebird-support] IF ELSE in Select Statement |
---|---|
Author | Chad Z. Hower |
Post date | 2005-02-28T13:43:24Z |
:: >Select * From TEST_TBT
:: > Where (i=1) AND (Field_1 = 'AAA') OR (i=2) AND Field_2 = 'BBB';
::
:: Cute! :-)
You can do some neat tricks on this variant with unions too. Before we used
a framework to do transofrmations and were doing simple client server apps
we had to do all kinds of wierdo SQL tricks.
:: > Where (i=1) AND (Field_1 = 'AAA') OR (i=2) AND Field_2 = 'BBB';
::
:: Cute! :-)
You can do some neat tricks on this variant with unions too. Before we used
a framework to do transofrmations and were doing simple client server apps
we had to do all kinds of wierdo SQL tricks.