Re: Verifying a variable only contains letters and not punctuation...

Use INSTR to check punctuations.

to Check for Valid Number You can Write a Function :

Create or replace Function Valid_Num (pInStr IN Varchar2) Return Boolean IS
  temp number;
Begin
  Temp := To_Number(pInStr);
  Return True;
Exception
  When Value_Error Then
    Return False;
  When Invalid_Number Then
   Return False;
End;

Sunder.

Bryan J. Gentile wrote:

> Is there a way in PL/SQL to check for all punctuation marks such as
> commas, periods, etc. I will not know what the punctuation mark will
> be
> therefore, I cannot really use the REPLACE(variable, ',', '')
> function.
> I would rather use something more reliable. Is there something that
> PL/SQL has to do this?
>
> Also, if I wanted to check that a variable of type NUMBER was only
> numbers, how could I do that?
>
> --
> ************************************
> Bryan J. Gentile
> Consultant
> Business Data Services, Inc.
> Glastonbury, CT 06033
> Phone: (860)633-3693 (ext. 3025)
> Vmail: (ext. 6030)
> ************************************
Received on Fri Oct 24 1997 - 00:00:00 CDT