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

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)


************************************