Michael Pemberton wrote: > > Is there some way of getting mysql to test this value on the fly? http://dev.mysql.com/doc/mysql/en/CASE_Statement.html