Am Mittwoch, 3. März 2004 08:36 schrieb Michal Pasternak:
> Certainly.
>
The first expr is optional, so in this case you could use:
SELECT name_pl,
CASE
WHEN is_cenatel='t' THEN '('
ELSE (CASE
WHEN ((sale_since < %s) + (sale_until > %s)) TH
Pierre-Yves Delens [Tue, Mar 02, 2004 at 09:01:04PM +0100]:
> does someone have some example snippets for using the CASE-WHEN expression
> in SqLite ?
Certainly.
SELECT name_pl,
(CASE is_cenatel='t' WHEN 1 THEN
'('
ELSE (CASE ((sale_since < %s) + (sale_until > %s
Bonjour,
does someone have some example snippets for using the CASE-WHEN expression
in SqLite ?
Thanks on forward
___
P-Y Delens
___
--
3 matches
Mail list logo