String and date format

How can I specify that the type of a column is 4 characters where the two first are capital letters and the two last are digits?

I guess it could be something like this: CREATE TABLE MyTable(

    MyColumn CHAR(4) CHECK (MyColumn LIKE ([A-Z][0-9]))     );

Second question, can I specify a specific date format (i.e. DD-MM-YYYY) for a specific column or it is only for the entire session or when I query date from the table?

Oliiver Received on Wed Nov 28 2001 - 03:35:08 CET