How to validate a data field for A-Z, 0-9 and "*" in SQL Windows?

I'm trying to define the input mask for a field in SQL Windows. I now that setting "AAA" would make the field accept anything from A to Z; "999" would make it a开发者_Python百科ccept any number. But how do I make it able to accept the "*" char?

AFAIK you can't. At least according to the SQLwindows 2.1 documentation input masks only support numbers and alphabetic characters.
Have you considered creating your own class? Intercepting the SAM_AnyKey-message and checking the characters against your mask should do the trick.