• Eugene Elutin (12/3/2012)


    ... does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions?

    That is correct.

    Sorry;

    My question is;

    Do I understand the CASE logic correctly and does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions?

    OR

    Does it do EVERY CASE WHEN check and hold the last one as the description ?

    So if I put an initial check in saying ... CASE StockCode like 'Stock%' Then 'Yippee'

    ALL Records would fall into this and no other categories would be highlighted.

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

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