Here's another, quicker way to do it.
SELECT column1,
column2,
COALESCE(maybe_null_column, 'NULL')
FROM your_table;
Note: If maybe_null_column is not a character data type,
then you need to coerce it. ie: maybe_null_column::text
---(end of broadcast
You can do that now with a little code as follows:
SELECT column1,
column2,
CASE WHEN maybe_null_column IS NULL THEN 'NULL' ELSE
maybe_null_column END
FROM your_table;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ketema Harris
Sent: Thu
