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]
