SQL CHECK() how to check if input is numeric value?

Question

Hey how can I check if the input has 5 numbers? I tried everything like isnumeric/LIKE '%[0-9]%' they all not working...

I tried the following but it doesn't work.. please help

CREATE TABLE Code ( PIN TEXT NOT NULL, CHECK(LENGTH(title) = 5), CHECK(title LIKE '[0-9][0-9][0-9][0-9][0-9]'));

forpas · Accepted Answer · 2021-10-16 14:54:36Z

1

You can use GLOB operator:

CREATE TABLE Code ( 
  PIN TEXT NOT NULL,
  title TEXT,
  CHECK(title GLOB '[0-9][0-9][0-9][0-9][0-9]')
);

See the demo.

answered Oct 16, 2021 at 14:54

forpas

165k10 gold badges51 silver badges85 bronze badges

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

1 Answer 1