Quick Help

Thea_DiSalvo

I keep getting a syntax error.  What am I missing?

 

CASE WHEN `invoice number` = 325940

THEN `customer code` = 'CS10003'

ELSE `customer code`

END 

MarkSnodgrass

Try this

CASE WHEN `invoice number` = 325940

THEN 'CS10003'

ELSE `customer code`

END 

MarkSnodgrass

Try this

CASE WHEN `invoice number` = 325940

THEN 'CS10003'

ELSE `customer code`

END 

Thea_DiSalvo

thank you worked like a charm, I was definitely overthinking.