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]