subject says it all. i'm looking for oracle's equiv of COALESCE(), which (at least in sql server) selects the first non-null value in a list passed as arguments. thanks, -- mattwarden mattwarden.com