Yup... but it will pick up "Whole Numbers"
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA7035CC1FC_at_lnewton.leeds.lfs.co.uk...
> It's me again !
>
> One thing, scanning through char by char will not pick up valid numbers
> such as :
>
> 1e6 = 1,000,000
> 1.2345e-7 = 0.00000012345
>
> and so on. TO_NUMBER handles all of that.
>
> Beware !
>
> 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 Fri Feb 28 2003 - 06:46:19 CST
