sql - Liquibase script to make all data in a column uppercase -


i have problem data in particular column stored lowercase (this problem occurs in mssql).i had thought of writing change set force uppercase in particular column, not sure on how go it

try following changeset:

<changeset author="mark" id="2013-07-15-01">     <update tablename="mytable">         <column name="mycolumn" valuecomputed="upper(mycolumn)"/>     </update> </changeset> 

documented here.


Comments