Archives of the TeradataForum

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

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

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>>