I keep getting a syntax error. What am I missing?
CASE WHEN `invoice number` = 325940
THEN `customer code` = 'CS10003'
ELSE `customer code`
END
Try this
CASE WHEN `invoice number` = 325940THEN 'CS10003'ELSE `customer code`END
thank you worked like a charm, I was definitely overthinking.