Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 15:31:48 GMT


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


Subj:   "NOT LIKE ANY"
 
From:   Fred Easey

Getting a strange result here. I have a table which has a field called FORMAT_DESCRIPTION.

eg

     store_code   format_description
     ----------   ------------------
     0001         localsmain
     0006         localsother
     0008         main
     0010         centalsmain

I run this code:

     select
        store_code,
        format_description
     from
        stores
     where
        upper(format_description) not like any ('%LOCAL%','%CENTRAL%')
     ;

for some reason this code does *not* exclude any rows. If I we-write it so that the where clause is:

     where
        upper(format_description) not like '%LOCAL%' and
        upper(format_description) not like '%CENTRAL%'

...then it works fine. Why won't the first version work? Am I misunderstanding how NOT LIKE ANY works?

Please advise,


Thanks,

Fred



     
  <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