Re: [sqlite] Syntax for expression CASE WHEN

2004-03-03 Thread Tim Krah
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

Re: [sqlite] Syntax for expression CASE WHEN

2004-03-02 Thread Michal Pasternak
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

[sqlite] Syntax for expression CASE WHEN

2004-03-02 Thread Pierre-Yves Delens
Bonjour, does someone have some example snippets for using the CASE-WHEN expression in SqLite ? Thanks on forward ___ P-Y Delens ___ --