title: T-SQL: Count Numbers of semicolons before expression
body: <p>I got a table with strings that look like that:
  '9;1;test;A;11002'
  How would I count how many semicolons are there before the 'A'?</p>
  <p>Cheers!</p>