to_number from a varchar field.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Feb 2003 12:25:19 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70348E76A@lnewton.leeds.lfs.co.uk>

Oh Hum - I really must *read* what the question is before answering in future - sorry.

Stephan posted a function that you can use.

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


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

-----Original Message-----
From: heyvaert [mailto:pol.heyvaert_at_acunia.com] Posted At: Monday, February 10, 2003 12:03 PM Posted To: server
Conversation: to_number from a varchar field. Subject: Re: to_number from a varchar field.

this is OK for a record where NULL is filled in, but when the record is filled with a string,an 'ORA-01722: invalid number' exception is thrown.

Pol Received on Mon Feb 10 2003 - 06:25:19 CST