Hi All,

I have a report that is retrieving records from on Oracle database. The report is driven by a dropdown that is populated with data from the same oracle database. Some of the records have null values. When the null values are getting retrieved it appears they are getting padded with a space. So what should be null or '' is now ' '. Since I am using that value to query the database, I am getting no records returned because no records have a value of ' '.

Is there a way to get the padding to stop?

I am using WF 7.6.11 and Oracle 11g.

Thanks,
Cody

This message has been edited. Last edited by: <Kathryn Henning>,

Have a look at this about MISSING :
How to manage MISSING