title: Simple way to concatenate BIT and NVARCHAR columns
body: <pre><code>MyTable
  =======
  Item NVARCHAR(200)
  Hidden BIT
  </code></pre>
  
  <hr>
  
  <p>I need to load all the items from <code>MyTable</code> in a <code>DropDownList</code> in such format: Item (Hidden)</p>
  
  <p>This how my list would look like:</p>
  
  <pre><code>Brush
  Table (Hidden)
  Box (Hidden)
  PC
  Ball
  </code></pre>
  
  <p>N.B: I've reached in my search to this SQL entry: </p>
  
  <pre><code>SELECT        ID, Item + '(' + CAST(Hidden AS NVARCHAR(200)) + ')' AS Conct
  FROM            Items
  </code></pre>
  
  <p>Which Returns Item(0) or Item(1)</p>
  
  <p>..I can't think of a simple way to use for my purpose but I thought I'd change the Hidden column to NVARCHAR and store hidden or blank in it .. or maybe add another column that stores the word 'Hidden' for any '1' in the Hidden (BIT) column. What do you think guys ?</p>