The best way to deal with this long to term is to fix the database design. What would I have to do in order to make the design change?