I am using MS reporting services sql server 2005 creating a report that needs to pass a null value through a parameter to the oracle db being queried.
have tried "AND ip.BOOKING_CONFIRMED_IND -= nvl(:PARAM3,'NoBooking ')" which returned nothing.
this field "BOOKING_CONFIRMED_IND" uses 'Y' or 'N' as values,
however it can be empty if a booking has not been made. It is these records I want to retrieve.