• This is also the way I have done things. We have a form with 7 check boxes for days of the week, the user can

    check any combination and this can be stored neatly and efficiently as 1 tinyint range [0-127]. The bitwise queries to retrieve

    the data are also efficient and very useful once you have taken the time to understand the maths behind the operations. The alternative

    is 7 database fields and queries with lots of OR operators - a lot more work to product some ugly queries.

    Regards,

    Andy Jones

    andyj93@hotmail.com

    .