title: How to build string query with NHibernate?
body: <p>I would like to reproduce this query with NHibernate using projection</p>
  
  <pre><code>SELECT ('reword#' || reword) || reword_faq as foo FROM me_review_entries re
  WHERE ('reword#' || reword) || reword_faq = 'reword#2#SOME_FAQ'
  </code></pre>
  
  <p>I did</p>
  
  <pre><code>Session.CreateCriteria&lt;Reword&gt;
  </code></pre>
  
  <p>But then I don't know I could do projection to build the string <code>('reword#' || reword) || reword_faq</code></p>
  
  <p>Any Idea ?</p>