title: How to convert (cast) int to ntext
body: <p>I need to convert <code>int</code> field like <code>1005</code> to <code>ntext</code> alike <code>Alarm1005</code>, but <code>CAST(ID as ntext)</code> doesn't work, so how can I convert(cast) <code>int</code> to <code>ntext</code> ?</p>