title: get the string after certain character or specific character in SQL Server
body: <p>I have a pattern of strings like in column "remarks":</p>
  
  <pre><code>remarks
  pay mode: called to pay
  pay mode: cash
  pay mode: bank deposit
  pay mode: from third party
  </code></pre>
  
  <p>I have to select all the string after the <code>pay mode:</code>. One way is to retrieve all the strings after the first appearance of <code>:</code> in value or select all the strings from left after 9 characters from left. </p>
  
  <p>How can I do this in SQL Server?</p>