Liquibase script to make all data in a column uppercase

Question

I have a problem where the data in a particular column is stored as lowercase (This problem occurs only in MSSQL).I had thought of writing a change set to force uppercase in that particular column, but I am not sure on how to go about it

Answer 1

Try the following changeset:

<changeSet author="mark" id="2013-07-15-01">
    <update tableName="MyTable">
        <column name="MyColumn" valueComputed="upper(MyColumn)"/>
    </update>
</changeSet>

Documented here.