Hi

We use DB2 8.2.6 on windows 2000.

Would like to force value of a column in a table to be always stored in lower case. i.e even if some one inserts in mixed case.

Is there a facility in DB2 to do this?


Regards

Harikumar

You can use 2 triggers (insert after and update after) to do this. Use the lower function to change the value every time a row is inserted or updated.

I'd suggest to use a BEFORE trigger and set the value to lowercase before the insert or update is performed.

Another alternative is to use views and instead-of triggers. Thinking about views, you could also store the data in mixed-case in the table and mask this with a view. Blair Adamache wrote an article about that a while ago.

Thanks for the suggestions. We like the idea of masking with views and may implement that

Regards

Harikumar

I collected a few variations on case-insensitive string operations in DB2 here: http://www.ibm.com/developerworks/db...dm-0712stolze/