check constraint with input mask

[dafreki]

I'm having an impossible time figuring out how to do a check constraint with an input mask. The user has to input a code in the format AAA9, A being any letter and 9 being any number.
I can't get past Check(UserCode LIKE ........
Is there anything in oracle that's equivalent to [A-Z] and [0-9]? If anyone could help, it would be greatly appreciated.

 

[stefanhei]

Hi.
A possible workaround would be the TRANSLATE-function:
CHECK( TRANSLATE( UserCode,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'9999999999AAAAAAAAAAAAAAAAAAAAAAAAAA') ='AAA9')

Stefan