Check constraint not reading [A-Z]?

Question

I am having an issue with a check constraint reading [A-Z].

here is the code:

drop table test CASCADE CONSTRAINTS; Create table test ( post Varchar2(6), CHECK (post like '[A-Z]') ); insert into test values ('A');

And I receive a "check constraint violated" error after trying to insert A. Any feedback would be appreciated. Even if it does work for you because everything is telling me it should work.

What is your version of SQL (e.g. MySQL, SQL Server, Oracle, Postgres, etc.) ? — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 22, 2021 at 4:44
The way you put it, only insert into test values ('[A-Z]') would work. It is regexp_like you're looking for (see Tim's answer). — Littlefoot
– Littlefoot, Commented Apr 22, 2021 at 5:12

Tim Biegeleisen · Accepted Answer · 2021-04-22 05:16:02Z

Use REGEXP_LIKE:

CREATE TABLE test ( post Varchar2(6), CHECK (REGEXP_LIKE(post, '^[A-Z]+$')) );

The pattern ^[A-Z]+$ would match posts which only contain capital letters. If instead you want to flag posts which begin with a capital letter, then use ^[A-Z].

Collectives™ on Stack Overflow

Check constraint not reading [A-Z]?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related