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.