Inserting '-' in place of blanks in a column
From: Erwin <erwincisco_at_yahoo.com.sg>
Date: Wed, 21 May 2003 05:13:36 GMT
Message-ID: <4WDya.1202$Ac3.13956_at_news-server.bigpond.net.au>
Date: Wed, 21 May 2003 05:13:36 GMT
Message-ID: <4WDya.1202$Ac3.13956_at_news-server.bigpond.net.au>
Hi,
Is it possible to insert the symbol '-' in the column where the value of the field is NULL and the field datatype is integer? I have tried using rpad and to_number function but it does not work.
Thanks Received on Wed May 21 2003 - 07:13:36 CEST