• Sorry - that seems to be working as expected -

    Thanks -

    I think when I tried that I had "CASE fieldname WHEN" rather than "CASE WHEN fieldname"

    Regards

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.