On Fri, Feb 29, 2008 at 10:25 AM, Erik Cederstrand <erik(at)cederstrand(dot)dk> wrote: > How would I go about this? This smells like EAV. Please read http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html and consider reevaluating the schema according to valid relational design (tables, columns, check constraints, etc.). In any case, good luck.