I'd give a provisional "yes" - all CASE does is say which stuff goes
into the final SQL statement - it is often used to change what the ORDER
BY is that will be executed.
I think you can think of the stuff in the WHEN's as just character
strings of which only one is used - perhaps on a row-by-row basis.
On 5/8/2014 11:25 AM, Stone, Joel wrote:
set KEYWORD5 = KEYWORD1,
KEYWORD9 = KEYWORD2,
KEYWORD8 = KEYWORD3,
KEYWORD1 = ' ',
KEYWORD2 = ' ',
KEYWORD3 = ' '
Or must I use many CASE statements to do this?
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com