title: SQL column to display the same value
body: <p>I have a database that I am using for my query in which one column has several typos. </p>
  
  <p>This is a huge data base and the typos due to multiple people inputting the data and doing it their own way. I've decided to just have that column display one word.  </p>
  
  <p>For example, the column header is state in which the only state name in the column under location that  is <code>Mississippi</code>.  </p>
  
  <p>The problem is, I've come across words like <code>Miss</code>, <code>MS</code>, <code>IS</code>, <code>Ms</code>, <code>mS</code>, <code>Misisipi</code>, <code>Missippi</code>, etc.  </p>
  
  <p>I just want the location column to display <code>Mississippi</code> and it is hard for me to capture all of the current typos and any future typos that may be loaded into the database.  </p>
  
  <p>Is there a way for me to just have the location column in my query to have <code>Mississippi</code> on every row. Thanks!</p>