Does anyone know of a function using PL/SQL that checks the value of a variable to see
if it contains all numbers or number and alpha. I originally planned on doing this in
CF with the IsNumeric check but just got shot down to do it the oracle Function Im
writing.
Thanks,
Misty
PM
Subject: [KCFusion] Numeric Check in PL/SQL
Does anyone know of a function using PL/SQL that checks the value of a
variable to see if it contains all numbers or number and alpha. I originally
planned on doing this in CF with the IsNumeric check but just got shot down
to do it the oracle
IF;
END;
END;
-Original Message-
From: Misty Woodward [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 1:07 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Numeric Check in PL/SQL
This doesnt work in a block of code. Here is what I am going for, FN_ISNUMERIC