Hello,

I have a grid where I am displaying the "Check" or "Blank" for
a boolean value, but sometimes that boolean value is "Null"
because it is being retrieved from another file and the record
doesn't exist there.

My users don't want to see the "?" which is drawn if the field
if null. They would prefer to see a empty cell. They say it
just distracts them from because they are looking for checks
and it takes extra time to determine that it is a "?" instead
of a check.

Below is the SQL used to get the data, OM_SHIPRESIDENTIAL is the
field that is causing the problem.

How can I get it to display a "empty" cell instead of a "?".

Thanks
Michael L. Horne


select
UR_ID,
UR_POS_ID,
UR_POM_ID,
UR_OM_ID,
UR_RECONCILED,
UR_TRACK_NO,
(select b.om_shipresidential from ordersm b
where (UPS_RECONCILIATION.ur_om_id = b.om_id)) as om_shipresidential
FROM UPS_RECONCILIATION