From: jmclaugh@cscc.edu
Subject: Alphabetical
Date: 1997/08/08
Message-ID: <871080906.13587@dejanews.com>#1/1
X-Http-User-Agent: Mozilla/4.01 [en] (Win95; I)
X-Originating-IP-Addr: 198.30.79.91 ()
Organization: Deja News Posting Service
X-Authenticated-Sender: jmclaugh@cscc.edu
X-Article-Creation-Date: Fri Aug 08 22:55:06 1997 GMT
Reply-To: jmclaugh@cscc.edu
Newsgroups: comp.databases.oracle.misc



Ok here's a gooden.

I am creating a table with this column and check in it:

mcf_custnum   char(25) CHECK(mcf_custnum BETWEEN 'A' AND 'z'),

I am trying to check the whole string to see if it has capital or
lowercase a thru z.  If it doesn't, the record isn't allowed in the table.
 I am sorry if I sound like a newby, but I am and this is really
frustrating.  Using Oracle 7.X.  The above piece of code will only check
the first character and ignore the rest.

Joel McLaughlin

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet