>I wish there was also equivalent of NVL() to Sql Select so that I would not have to have 2 SQL Select statements for each database.


ISNULL(mytable.myfield,'Null Value Detected') as NonNullField

or

COALESCE(mytable.myfield,'Null Value Detected'') as NonNullField