> I can confirm this issue.
>
> We recently updated to 4.8 und have the same problem everywhere we use
> a filter with an upper(). But it also affect filters with max() or min().
> So Filters as: (UPPER(XX.CUSTOMER_NAME) LIKE 'HELEN%')
> appends the where clause: AND UPPER(XX.CUSTOMER_NAME) AND LIKE 'HELEN%'
>
> The ::SQL:: prefacing did the trick, but this is no good situation
> because it worked without any turnaround or knockout in 4.5.
>
> Would be great if you'll find some time to take a look into. greatly
> appreciate if it can fixed in a further version.

I definitely plan to get this fixed as soon as I can.

Thanks,
Jason L Wharton