Archives of the TeradataForum

Message Posted: Thu, 31 Aug 2000 @ 17:28:31 GMT

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

Ooh, so close yet so far !

Try concatenating a space before both the 'input variable' and the formatted version of Store_No. For my macro that would be;

     replace macro m1
     (invar varchar(255))
     as
     (select *
       from t1
       where index(' '||:invar||' '  ,  ' '||trim( leading from (c1 (format
     'zzzzzzzzz9'))||' '  )   )  >0;);

Regards,

Dave

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