I have an already existing SQL function running in Marketing Cloud and have been attempting to add on a CASE function to determine a column of "State". I have tried a couple different versions of this and not recieved any syntax errors, however it is not functioning as I intended.
The targeted Data Extension has a field of State so the case results would transfer from the current column Home_Area__c to State. Additionally the results from the evaluation would drop into that column.
Any ideas on what I am missing?