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]
