asked
case statement
I have a data set with three fields : RS / ABC / ~ RS / RCS / Pink RS / BDE / Pink BD / JEG / ~ BD / KEG / Red BD / PCO / Red So, I want to update RS ABC to be Pink and BD JEG to be Red using a case statement. When I write the case statement BD JEG is Pink and then RS ABC is Red. How can group all RS data to be Pink and all BD data to be Red when ~ is an indicator in both pink and red?
Not sure you would need a case statement. Wouldn't a simple WHERE clause get the job done? UPDATE MyTable SET Color = 'Red' WHERE ColumnA = 'BD' AND Color = '~';
14 People are following this question.
