Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 09:35:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I assume that the AGE column is a character string. Teradata has a 'like an operator' that may work in this context (untried)

     Create macro get_age (AGEPARAM varchar(30) )
     As
     (
     Select ...
     Where AGE like any (:AGEPARAM));

     Exec get_age  "'> 12','< 30'"

Barbara

	<Prev	Next>		<<First	<Prev	Next>	Last>>