Home » Developer & Programmer » Reports & Discoverer » comparing an existing field with an empty string
comparing an existing field with an empty string [message #267580] Thu, 13 September 2007 14:24 Go to next message
Messages: 12
Registered: May 2007
Junior Member
Hi all,
I am quite new and not experienced in Oracle discoverer.
I have a problem while creating reports.
I need to create a report which compares an existing field(a column called 'units paid'which is of type number)to an empty field and produce the result.Can anyone help me throughout...Its not a NULL value..sould be compared to empty string.is there any function???

Re: comparing an existing field with an empty string [message #267585 is a reply to message #267580] Thu, 13 September 2007 15:02 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So you are comparing a NUMBER and an empty STRING.

For example: 23 > ' '

Just being curious: what do you expect as a result?

I'd use TO_CHAR function and try with
TO_CHAR(23) > ' '
but it will always return "yes, 23 is greater than ' '".

Or, you might use the REPLACE function and remove all those "spaces" or TRANSLATE to translate them into a '0' (string, zero) and TO_NUMBER to make it comparable with a number.

I must admit, I don't see a point here.

Previous Topic: How to achieve in DECODE
Next Topic: Reports 6i/10g to Discover
Goto Forum:

Current Time: Sat Jul 22 06:24:47 CDT 2017

Total time taken to generate the page: 0.32413 seconds