Subject | Re: [firebird-support] Enabling only numbers at field varchar(11) |
---|---|
Author | unordained |
Post date | 2012-07-03T19:21:43Z |
---------- Original Message -----------
From: "Ismael L. Donis Garcia" <ismael@...>
http://www.firebirdsql.org/refdocs/langrefupd25-similar-to.html
I've not used FB regular expressions yet, but my first stab would be:
alter table ... add constraint ... check (value similar to '[[:DIGIT:]]{11}');
-Philip
From: "Ismael L. Donis Garcia" <ismael@...>
> As I could validate that an alone field of varchar(11) enabled numbers------- End of Original Message -------
> and that these had 11 characters of length?
http://www.firebirdsql.org/refdocs/langrefupd25-similar-to.html
I've not used FB regular expressions yet, but my first stab would be:
alter table ... add constraint ... check (value similar to '[[:DIGIT:]]{11}');
-Philip