title: How do I get a specific string UNTIL a specific character out of a string in SQL Server?
body: <p>I have this string:</p>
  
  <p>Blah blah blah - 2389023823</p>
  
  <p>I want to grab everything to the LEFT of the dash:</p>
  
  <p>"Blah blah blah"</p>
  
  <p>How do I go about doing this?</p>
  
  <p>I'm assuming I would have to do <code>LEFT()</code> with <code>ChARINDEX() + LEN()</code> somehow but I'm having difficulty.</p>
  
  <p>Appreciate the help.</p>