>

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.

Regards,


Ann