title: Concatenate first and last name with last name all in uppercase
body: <p>I need to make a mysql query that displays all first names concatenated with the last name in uppercase, with a space between first and last name.</p>
  
  <p>What I've got atm:</p>
  
  <pre><code>SELECT CONCAT_WS(" ", `First_Name`, `Last_Name`) AS Name from tblDetails
  </code></pre>
  
  <p>I'm new to mysql and I can't figure out where to put UPPER, doesn't seem to work anywhere.</p>
  
  <p>Also I need to do the same as above but add a prefix of Mr or Ms depending on the gender.</p>