| Subject | Re: [firebird-support] CHECK for all numeric characters |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2005-09-01T18:19:57Z |
In case the concatenated string resembles number with exponent
CHECK ( CAST ('1' || Value) BETWEEN 100000000000 199999999999 AND Value NOT CONTAINING 'e')
Ivan
CHECK ( CAST ('1' || Value) BETWEEN 100000000000 199999999999 AND Value NOT CONTAINING 'e')
Ivan