title: Extract words from # separated string in SQL Server
body: <p>I have a requirement wherein I have to extract a <code>#</code> separated string as </p>
  
  <pre><code>Declare @Text nvarchar(255) ='Test1#Test2#Test3#Test4'
  
  Declare @FirstWord  nvarchar(255) 
  Decalre @SecondWord nvarchar(255)
  </code></pre>
  
  <ul>
  <li><code>@FirstWord</code> will contain "Test1" and </li>
  <li><code>@SecondWord</code> will contain "Test2 Test3 Test4"</li>
  </ul>