9.5 Upgrade - DAudit to DAuditNew

Gari_Harrington

We have recently upgraded to 9.5. I am trying to change all of our custom LiveReports that are affected by the DAudit / DAuditNew tables. DAudit values were all uppercase, DAuditNew values are all proper case. My question is will I have to write SQL to capture both the proper and uppercase values to capture all the new and old data? where LOWER(b.auditstr) LIKE LOWER ('%%'||'login'||'%%')"Or will all the DAudit uppercase values be converted into proper case during the upgrade?