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

[JeffPace]

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

[JeffPace]

Ours is simple select using nvl

works at 10
fails at 10.2

[JeffFerdinand]

The following explains the issue.  I have followed the steps.  Our queries are now processing properly.  http://support.esri.com/en/knowledgebase/techarticles/detail/41561