Re: enforcing alphabetic/numeric content in "char" column

On Thursday, November 7, 2002, at 10:31 , Bruno Wolff III wrote:

> On Thu, Nov 07, 2002 at 19:37:23 +0530,
>   Joel Rodrigues <borgempath@Phreaker.net> wrote:
>>
>> iso3dnum    char(3) CHECK (iso3dnum ~ '[0-9]')
>
>   iso3dnum    char(3) CHECK (iso3dnum ~ '^[0-9][0-9][0-9]$')
>

Thank you Bruno & Rod ! This one works. So it's one [0-9] for
every character.

Obrigado !
Joel