Re: Validating that a field is Alpha

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 4 Apr 2000 17:09:12 GMT
Message-ID: <8cd7jo$76s$1@relay1.dsccc.com>

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_at_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. Received on Tue Apr 04 2000 - 12:09:12 CDT