comparing an existing field with an empty string [message #267580] |
Thu, 13 September 2007 14:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
a.vincent727
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???
Thanks
|
|
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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 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.
|
|
|