title: SQL [Conversion to bool]
body: <p><strong>C++Builder ADOQuery SQLServer</strong></p>
  
  <p>I'm using a stored procedure with this select</p>
  
  <pre><code>SELECT  Name,
          COALESCE(
          (
          SELECT  TOP 1 0
          FROM    TbUserParam
          WHERE   TbUserParam.ID_User = @ID_User
                  AND TbUserParam.ID_Param = CfgListParIzm.ID_ListParIzm
          ), 1) Visi
  FROM    CfgListParIzm
  WHERE   CfgListParIzm.ID_ListGroupParIzm = @ID_ListGroupParIzm
  </code></pre>
  
  <p><a href="https://stackoverflow.com/questions/2109489/sql-hard-query-to-make-or-to-avoid">Stuff about this query</a></p>
  
  <p>in my query with SQL string :</p>
  
  <pre><code>FlowClientHardQ  :ID_User, :ID_ListGroupParIzm
  </code></pre>
  
  <p>then DataSource and DBGrid with CheckBox fields. <a href="http://delphi.about.com/od/usedbvcl/l/aa082003a.htm" rel="nofollow noreferrer">Source</a></p>
  
  <p>So I need a bool (or bit) field there from my ADO Query.
  How / Where can I convert it ?</p>
  
  <p>Thank you.</p>