Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 17:51 Go to next message
Jeremy Schreier is currently offline Jeremy SchreierFriend
Messages: 1
Registered: May 2018
Junior Member
Can anybody explain how to correctly type in the UPPER function into a converted SQL filter.

Currently I am using


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.

Re: UPPER in analysis query [message #1786994 is a reply to message #1786881] Thu, 17 May 2018 01:31 Go to previous message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 69
Registered: July 2009
Location: Salt Lake City, UT
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:

Current Time: Mon Nov 12 21:45:13 GMT 2018

Powered by FUDForum. Page generated in 0.01632 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top