I have a small "Attribute-Value" table, and a UDF to go with it.
Then I can do SELECT * FROM Orders where PaymentType = dbo.fn_SystemInfo('VISA'). Unfortunately this results in a convertion to/from varchar which may not be efficient. But it is easy on the eye to read the code.
Your suggestion would help a lot.
Best regards
Henrik Staun Poulsen