Re: Checking LONG datatype for NULL

gburton_at_cbis.com (Glenn Burton) wrote:
>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
>_________________________________________

Hey this is a long-shot but how bout:

SELECT 'message'
FROM <table>
WHERE <long_column> IS NULL

NVL is used to convert null values to other values.

Hope that helps. Received on Thu Mar 14 1996 - 00:00:00 CET