There is also an SQL NVL() funciton which works a little different.

NVL(fieldname, string)

returns non-null values. The string is inserted where a null is found, such as
"NO DATA"

Greg