Received: from web14910.mail.yahoo.com (web14910.mail.yahoo.com [216.136.225.62]) by postgresql.org (Postfix) with SMTP id 074BC4750F5 for ; Tue, 9 Apr 2002 08:00:00 -0400 (EDT) Message-ID: <20020409120003.46895.qmail@web14910.mail.yahoo.com> Received: from [202.161.138.9] by web14910.mail.yahoo.com via HTTP; Tue, 09 Apr 2002 05:00:03 PDT Date: Tue, 9 Apr 2002 05:00:03 -0700 (PDT) From: "Kancha ." Subject: replace NULL To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200204/95 X-Sequence-Number: 7360 Hello i want to run a select query on a table. eg: select age from people; if age is NULL then I want to replace it by some text, say "SHY" so the output is like name age me 10 jane SHY jack 32 how do i make this replacement of null value to some text __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/