Re: check if numeric

[John Milardovic <milardj@SX.COM>]

One method is to do a to_number function on it.  If it is an invalid number
then the function will return a 0.  Of course you will have to test if the
number was a 0 in the first place.

HTH
John Milardovic

> -----Original Message-----
> From: sally.g.librilla@AC.COM [SMTP:sally.g.librilla@AC.COM]
> Sent: Thursday, December 16, 1999 5:25 PM
> To:   SQR-USERS@list.iex.net
> Subject:      check if numeric
>
> Hello Everyone,
>
> Quick question : How would I know that the value of the variable I am
> using is
> numeric or not?
> I need to make sure that all characters contained in a variable is a valid
> number value.
> Otherwise, I need to report it as invalid value.
>
> Thanks.
>
> ps : you can guess this is still part of the validation program where my
> first
> question came from.