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

Regards,

Dave



     
  <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: 27 Dec 2016