InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 21:32:18 GMT20http://www.teradata.com/teradataforum/Topic11045-1-1.aspxYou can use paramenter in macro,for example:create macro testm(iday char(10)) as(select case when date=:iday then 1 else 0 end;);usage:exec testm('2008-03-29');Sat, 29 Mar 2008 09:39:08 GMTJianhttp://www.teradata.com/teradataforum/Topic11045-1-1.aspxCan a variable be used inside a case statement like so:SELECT (CASE WHEN Year_id = :v_Year_id THEN 1 END)FROM ......Wed, 26 Mar 2008 11:40:16 GMTmarcmc