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 
                '<SPAN STYLE=font-family:Wingdings;>(</SPAN>' 
       ELSE (CASE ((sale_since < %s) + (sale_until > %s)) WHEN 1 THEN
                sale_price 
               ELSE 
                price_cache_tax 
               END)
       END), 
       is_extra_bold 
       FROM ek_store_wares WHERE pk2_group_serial = '%s' ORDER BY  sort_type, name_pl

-- 
Michal Pasternak :: http://pasternak.w.lub.pl :: http://winsrc.sf.net
"There's so much comedy on television. Does that cause comedy in the streets?" 
        -- Dick Cavett

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to