Subject Re: [firebird-support] Re: CHECK for all numeric characters
Author Ivan Prenosil
> You are also correct. Perhaps I should cast it as NUMERIC(11,0).

Now I see the solution I sent yesterday arrived distorted somehow
(I have no idea how it could happen, since I copy/pasted it from isql),
so I will try again:

CHECK ( CAST ('1' || Value AS BIGINT) BETWEEN 100000000000 AND 199999999999
AND Value NOT CONTAINING 'e')

Ivan