jeff.pace

Query with "nvl" not working at 10.2, works at 10sp5

Discussion created by jeff.pace on Feb 4, 2014
Latest reply on Feb 20, 2014 by jwferdinand
I have a query (where clause) that does not work at 10.2
The identical query works at 10sp5.  Data are stored in oracle

any ideas?

nvl(PROP_HN,' ') LIKE '1112%'
AND nvl(PROP_SN,' ') LIKE UPPER('MANATEE%')
AND nvl(PROP_ST1,' ') LIKE UPPER('AVE%')
AND nvl(PROP_ST2,' ') LIKE '%'
AND nvl(PROP_DIR,' ') LIKE '%'
AND (nvl(PROP_PLC,' ') LIKE '%'
OR nvl(PROP_PLC,' ') LIKE '%'

Outcomes