A column with Check constraint that accepts only caps A to caps Z

Question

I have a column of varchar2(30) with not null and check constraint.

My problem is, I want that column to accept only caps A to caps Z only by using check constraint. How do I do this?

What RDBMS and version are you using? SQL Server? Oracle? MySQL? Something else? — LittleBobbyTables - Au Revoir
– LittleBobbyTables - Au Revoir, Commented Aug 18, 2012 at 14:35

João Silva · Accepted Answer · 2012-08-18 15:40:06Z

2

CONSTRAINT check_column_name CHECK (REGEXP_LIKE(column-name, '^[A-Z]+$'));

Here's an sqlfiddle exemplifying it.

answered Aug 18, 2012 at 15:22

91.8k29 gold badges156 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1