Subject Re: [firebird-support] CHECK for all numeric characters
Author Ann W. Harrison
Rick DeBay wrote:
>>I'm creating a domain that's CHAR(11) and I'd like to add a check to
>>make sure all the characters are numeric. I'm experiencing a brain
>>freeze right now and can't come up with one. Can anyone suggest the
>>appropriate CHECK statement(s)?
>David Johnson wrote:
> Have you considered declaring the column as numeric (11,0)?

If you do, included a check that the value is less than 100,000,000,000.
We don't enforce the upper (or lower) range of numeric values. Even
though the standard says we should.