SQL Server query to remove the last word from a string
<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>