to_number from a varchar field.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Feb 2003 11:07:35 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70348DF43@lnewton.leeds.lfs.co.uk>

Try :

select to_char(nvl(col1,'0')) from testtable;

If the column is NULL, NVL will be replaced by a character '0' which to_number will convert to zero.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Mon Feb 10 2003 - 05:07:35 CST