Subject Re: [firebird-support] SQL SERVER to FIREBIRD.
Author Milan Babuskov
akestion wrote:
> Can you tell me how to declare a check constraint such as :
> PRIMARY KEY check(typeAvion like '[A-Z]%'),

If all else fails, you can use SUBSTRING in a little awkward way:

check (substring(typeAvion from 1 for 1) between 'A' and 'Z')


Milan Babuskov