Subject | Re: [firebird-support] Re: CHECK for all numeric characters |
---|---|
Author | Ivan Prenosil |
Post date | 2005-09-02T15:23:23Z |
> 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