There is a knowledgebase article describing how to change user options in database view to display code table entries by the short or the long description: https://kb.blackbaud.com/knowledgebase/articles/Article/74975

I have just changed this option for myself in database view to view them by the short description, so that when I export addresses with queries, the state will come out as "OR" and not "Oregon" which saves a lot of time for our development team as they work on mailings.

However, this setting appears to only affect queries run in database view. I just ran one in web view and the state there came out as "Oregon."

If this option currently exists in web view, I haven't found it. Please make this setting an option in web view, too.