Subject Re: [firebird-support] CHECK for all numeric characters
Author David Johnson
On Thu, 2005-09-01 at 12:19 -0400, 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)?
>
> Thanks, Rick DeBay

Have you considered declaring the column as numeric (11,0)?