| comparing an existing field with an empty string [message #267580] |
Thu, 13 September 2007 14:24  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
