Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 15:58:13 GMT


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


Subj:   Re: "NOT LIKE ANY"
 
From:   McBride, Michael

          0001      localsmain
          0006      localsother
          0008      main
          0010      centalsmain

          upper(format_description) not like any ('%LOCAL%','%CENTRAL%')

The reason nothing is excuded is because, in the first case, 'localsmain' the substring 'local' begins in the first position, %local% will not excude that row, you would need to add 'local%' to account for starting at the beginning of a value. Secondly, %Central% would not work for the same reason, but you have an additional problem in that the value string your trying to exclude (I'm making an assumption here) is 'cental' not 'central' (which is may be a typo in the date?

Hope this helps?


Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters



     
  <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