Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need sql statement for complex address search
I ended up using NVL2
select ... where NVL2(MY_PREFIX, MY_PREFIX || '-' || MY_NUMBER, MY_NUMBER) like ... Received on Mon Jul 30 2007 - 18:28:25 CDT
![]() |
![]() |