title: Get the first space on the left of varchar SQL
body: <p>I have an Nvarchar column which contains 'John Smith    '</p>
  
  <p>I want to divide it to 'John Smith' and '    '</p>
  
  <p>Any idea how to do that? I tried the length but it don't take in consideration the left spaces </p>