|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 toIf you do, included a check that the value is less than 100,000,000,000.
>>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)?
We don't enforce the upper (or lower) range of numeric values. Even
though the standard says we should.