Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle isalpha() function?

Re: Oracle isalpha() function?

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Wed, 24 Nov 1999 13:41:02 +0100
Message-ID: <383BDCDE.C39676B3@unilog.fr>

Another way is to use the (nls_)upper and (nls_)lower functions. That is, if UPPER(c) is not equal to LOWER(c) then c is alphabetic, else, it is not !

Pierre. Received on Wed Nov 24 1999 - 06:41:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US