>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
Brandon Harker
Sebae Data Solutions