Add some column with number type to table which always has '0'(zero) as first character

Question

ADD COLUMN contact number(11)
CHECK(
SUBSTRING(
CONVERT(
CONTACT AS TEXT(11)
),1,1
)='0'
)

Answer 1

Supongo que podrias usar la expresion LIKE(0%,CONTACT) o tambien la expresion regular 0[0-9]+