title: SQL SERVER LIKE statement only works when inserting one Unicode character (doesn't work with multiple chars)
body: <p>I have some SQL query, like this:</p>
  <pre><code>SELECT ...
  FROM ...
  WHERE FIELD LIKE N'%ב%'
  </code></pre>
  <p>which works fine. but if I insert more characters, it doesn't return anything even it should (the field contains 'בוצע')</p>
  <pre><code>SELECT ...
  FROM ...
  WHERE FIELD LIKE N'%בו%'
  </code></pre>
  <p>And ideas? thanks!</p>