Checking LONG datatype for NULL

I would like to write a query that prints a message when a column of datatype LONG is NULL. My first thought was to use NVL to check for the presence of NULL, but this function isn't compatible with the LONG datatype.

Does anyone have a workaround that will permit the comparison of a LONG column with NULL?

Thanks in Advance!

--


_________________________________________

Glenn Burton 
glenn.burton_at_cbis.com
Cincinnati Bell Information Systems


_________________________________________