Xref: alice comp.databases.oracle.misc:56668
Path: alice!news-feed.fnsi.net!netnews.com!nntp.abs.net!uunet!ffx.uu.net!news.dsccc.com!dsun2.usa.alcatel.com!jstrange
From: jstrange@imtn.dsccc.com (John Strange)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Validating that a field is Alpha
Date: 4 Apr 2000 17:09:12 GMT
Organization: DSC Communications Corporation, Plano, Texas USA
Lines: 15
Message-ID: <8cd7jo$76s$1@relay1.dsccc.com>
References: <8cd2lk$46u$1@nnrp1.deja.com>
X-Newsreader: TIN [version 1.2 PL2]

could test the length of a Rtrim (Translate (var, alpha_chars, spaces).
If greater than 0 then non alpha character.
or
use Instr to see if char is in alpha string.



joelsung@my-deja.com wrote:
: In PL/SQL, I need to validate that a field (VARCHAR2(1)) is Alpha.   Is
: there a quick, easy way to do this?

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.