Re: to_number from a varchar field.

Thanks,got that,
but is there no other standard SQL function that can also be used on other DB-Platforms ?
I'm writing some java program that will filter out data from an existing database (from one of our customers). I'd like to generalize this sql for different platforms such as Oracle, DB2, Postgres, MySql, ...

Thanks anyway.

Pol

Norman Dunbar wrote:

> 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:46:27 CST