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 '<SPAN STYLE=font-family:Wingdings;>(</SPAN>' ELSE (CASE WHEN ((sale_since < %s) + (sale_until > %s)) THEN sale_price ELSE price_cache_tax END) END AS price, is_extra_bold FROM ek_store_wares WHERE pk2_group_serial = '%s' ORDER BY sort_type, name_pl --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]