title: Cast int to varchar
body: <p>I have below query and need to cast <code>id</code> to <code>varchar</code></p>
  
  <p><strong>Schema</strong></p>
  
  <pre><code>create table t9 (id int, name varchar (55));
  insert into t9( id, name)values(2, 'bob');
  </code></pre>
  
  <p><strong>What I tried</strong></p>
  
  <pre><code>select CAST(id as VARCHAR(50)) as col1 from t9;
  
  select CONVERT(VARCHAR(50),id) as colI1 from t9;
  </code></pre>
  
  <p>but they don't work. Please suggest.</p>