Re: Validating that a field is Alpha

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 04 Apr 2000 18:21:23 +0800
Message-ID: <38E9C223.5015@yahoo.com>

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?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

if upper(x) between 'A' and 'Z' then
  ...
end if;

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Tue Apr 04 2000 - 05:21:23 CDT