Is it possible, with a CASE or IF statement, changing the value of one field depending on the value of another one? I'm doing an exercise in which the next condition is required:
If country_code='NULL', the field 'country' must be 'Other'
Thank you for your help. Regards.