Home > Software engineering >  SQL ELSE take whatever the current value is
SQL ELSE take whatever the current value is

Time:01-06

Could you help me write the ELSE statement when nothing fits the above conditions? I just want it take whatever the current value is.

CASE
WHEN (Country IS NULL AND (NAME like '% US %' OR NAME like '%US-%')) THEN "US"  
WHEN (Country IS NULL AND (NAME like '% CA %' OR NAME like '           
  •  Tags:  
  • Related