title: First letter change to uppercase with MySQL SELECT
body: <p><a href="https://stackoverflow.com/questions/3278207/mysql-capitalize-first-letter-of-each-word-in-existing-table">This question</a> shows me how to create a function and then UPDATE a table making a column first letter uppercase which is pretty involved?  I simply want to output results where FirstName and LastName capitalize the first letter.  Right now they are a mixture of all uppercase, lowercase or correctly formatted.</p>
  
  <pre><code>SELECT FirstName, LastName, r.Email, min(ListingID) as ListingID, ListingFirmID
      FROM sancap_Residential_Property e 
      JOIN sancap_Agent r ON e.ListingAgentID = r.AgentID
      JOIN sancap_Office d ON e.ListingFirmID = d.firmID
      WHERE ListingFirmID != 'BrokerC'
  GROUP BY FirstName, LastName, r.Email, ListingFirmID
  </code></pre>