When optimizing a statement that has the following clause in it, I get an error that says, "Format '%s' invalid or incompatible with argument".
AND NVL(substr(upper(translate(i1.invoice_num,'a!@#/-_$%^&*.','a')), 1),'NomatchKluDge1') = NVL(
substr(upper(translate(i2.invoice_num,'a!@#/-_$%^&*.','a')), 4),'NomatchKluDge1')
Upgrade to SQL Optimizer 8.0. This version can be downloaded at https://support.quest.com/SUPPORT/index?page=downloads.
