We have some data that provides state abbreviations (i.e. AL, DC, NM, VA, etc.); however, we need to be able to transition those values to the full names of the states, or numbers (i.e. Alabama would be 1, Alaska 2, etc.). Is there any way to do this within a T-SQL query?