Hi all!

Is there any way to emulate oracle decode or sql server case features?

I need output different values based on other field. Someting like
that

select
decode(doc_type, 1, from_store, 2, to_store) store_number
from document

Ofcourse I can emulate it using union, but it's really sucks when
tables is huge, because it's twice more work for server :-(

Thanks beforehand!

Mike