Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Sat, 26 Apr 2008 @ 14:36:47 GMT





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




Subj:   Re: Can we use '%' with in the procedure for searching string
 
From:   Aldrin, John



Try converting it to a string literal in the final result:

     '... where ' || y.name || '  LIKE ''' || y.name1 || '%'';';




     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 16 Nov 2008