title: Creating a computed Int column in SQL Server from a text column
body: <p>I want to create a new column in an existing SQL Server table that utilizes state abbreviations (an existing column) to recode the states into a number (1-50) for statistical analysis that will be performed after exporting the output.</p>
  <p>Assuming that Alabama is AL = 1 and Wyoming is WY = 50, how would I go about doing this for every state?</p>