Re: Alphabetical

From: Sander Smit <Sander.Smit_at_cmg.nl>
Date: 1997/08/12
Message-ID: <01bca70c$e4405a00$6506130a@arjans.att.cmg.nl>#1/1

This is a possible solution:

check(lower(mcf_custnum)<>translate(lower(mcf_custnum),'abcdefghijklmnopqrst

uvwxyz','**************************'))

Sander Smit

jmclaugh_at_cscc.edu wrote in article <871080906.13587_at_dejanews.com>...
> 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
>
Received on Tue Aug 12 1997 - 00:00:00 CDT