Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 15:31:48 GMT
Getting a strange result here. I have a table which has a field called FORMAT_DESCRIPTION.
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|