title: Changing data type of column in a table from TEXT to LVARCHAR(10000)
body: <p>I want to change/modify the data type <code>TEXT</code> of column <code>batch_calc_query</code> in a table <code>d_etl_queries</code> to <code>LVARCHAR(10000)</code>. I am doing this by executing the following command:</p>
  <pre><code>ALTER TABLE d_etl_queries MODIFY (batch_calc_query LVARCHAR(10000));
  </code></pre>
  <p>But, it gives me the following error:</p>
  <pre><code>9633: ALTER TABLE can not modify column (batch_calc_query) type.  Need a cast from the current type
  </code></pre>
  <p>Is there any way I can avoid this error?</p>