Eclipse Community Forums: BIRT » UPPER in analysis query

Home » Archived » BIRT » UPPER in analysis query(I need help working in the UPPER expressions into my sql expression filter)

UPPER in analysis query [message #1786881]

Mon, 14 May 2018 13:51

Eclipse User

Can anybody explain how to correctly type in the UPPER function into a converted SQL filter.

Currently I am using

(UPPER("XXXX.XXXX")) <> "XXXX.XXXX"

Obviously XXXX = equals the table and data field.

The reason I am trying to do is because I am attempting to create a report showing me the values that do not match these two, but one is stored in upper case and the other in lower case and the its returning everything.

Thanks!

Re: UPPER in analysis query [message #1786994 is a reply to message #1786881]

Wed, 16 May 2018 21:31

Eclipse User

You don't need the "'s unless you are converting/comparing constants

As I read you statement you are comparing the literal TableA.XXXX to the literal TableB.xxxx

Previous Topic:	crosstab presentation problem - different row level measure's aggregation
Next Topic:	BIRT Runtime

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Mar 16 21:57:03 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter