I want to run a query to check the data in my (Inherited) databases are in the correct format.

I know that all the post codes in my database should be in the format of a Capital Letter, digit, digit, space, character, character, character
.i.e. G81 2PL

There was no input check on the data initially (I will be changing this) but is there a way of running a query to check that the format matches a certain criteria?

The only way I know to loook for a similar things is:-

Like "??? ???"
NOT Like "??? ???"

Anyone know how to check for letters or numbers/digits?