Alphabetical

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