+ 1

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

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

8th Aug 2018, 11:42 AM
Abhi
Abhi - avatar
1 Odpowiedź
0
Supongo que podrias usar la expresion LIKE(0%,CONTACT) o tambien la expresion regular 0[0-9]+
25th Aug 2018, 1:16 PM
Michaell Alavedra