#DateForumTypeThreadPost
130 Jul 2011 @ 01:48 PDTUDAReplyCase Statement Variable.can variables be used with 'then' clause of case statement?? example: select case when year='2011' and mon='jan' then :dayid else -100 end as day_id_key from ..............