Default Values in outer joins

Hello to everyone, is it possible to receive default values within an outer join instead of null-values? Example: Table A (ID INTEGER, NAME CHAR(10)) Table B (A_ID, ID, NAMECHAR(20)) SELECT A.NAME MASTER, B.NAME DETAIL FROM A, OUTER B WHERE A.ID = B.A_ID If there is no corrosponding row in table B, I would like to receive "NONE" in DETAIL instead of NULL Thanks, Volker -- Volker Fraenkle CS Controlling Technical Consultant Software Systeme GmbH E-Mail: VFraenkle@cs-controlling.de Phone: +49 7144 8144-0 Riedbachstrasse 5 Fax: +49 7144 8144-10 D-74385 Pleidelsheim