title: SQL Server query to remove the last word from a string
body: <p>There's already an answer for this question in SO with a MySQL tag. So I just decided to make your lives easier and put the answer below for SQL Server users. Always happy to see different answers perhaps with a better performance. </p>
  
  <p>Happy coding!</p>