Received: from nts-03.mm.eutelsat.org (nts-03.mm.eutelsat.org [194.214.173.15]) by postgresql.org (Postfix) with ESMTP id 5AEE247603A for ; Wed, 10 Apr 2002 06:03:33 -0400 (EDT) Received: from dell-01.mm.eutelsat.org (IDENT:root@dell-01.mm.eutelsat.org [194.214.173.17]) by nts-03.mm.eutelsat.org (8.9.3/8.8.7) with ESMTP id MAA00975; Wed, 10 Apr 2002 12:01:41 +0200 Received: from GMENDOLA2 (gmendola2.mm.eutelsat.org [194.214.173.26]) by dell-01.mm.eutelsat.org (8.11.2/8.8.7) with SMTP id g3AA3YF13292; Wed, 10 Apr 2002 12:03:34 +0200 Message-ID: <005501c1e076$f9f60fe0$5ce8fea9@GMENDOLA2> From: "Gaetano Mendola" To: "Kancha ." , References: <20020409120003.46895.qmail@web14910.mail.yahoo.com> Subject: Re: replace NULL Date: Wed, 10 Apr 2002 12:03:34 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/114 X-Sequence-Number: 7379 "Kancha ." wrote: > 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 UPDATE people SET age = 'SHY' WHERE age IS NULL; I hope that the field age is a text field; Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b");