Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Macro parameters
From:   David Wellman

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))
     (select *
       from t1
       where index(' '||:invar||' '  ,  ' '||trim( leading from (c1 (format
     'zzzzzzzzz9'))||' '  )   )  >0;);



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023