anthony.green (12/3/2012)
It hits the first true condition then terminates the case statement.
Thank you - I did feel this was the case but the data does not reflect the logic!?
Will now dig deeper.
Thank you
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.