CASE表达式语法报错：缺失')'问题排查求助

你的CASE表达式报错“缺少')'”，核心原因大概率是混淆了不同SQL方言的CASE语法，以下分两种场景给出解决方案：

场景1：在Salesforce SOQL中使用 #

你的写法符合SOQL的CASE函数语法，但可能因格式或隐藏字符导致解析错误。整理成清晰格式后，括号是完全闭合的：

CASE(
    Department_Text__c,
    "Administration", "Operations",
    "Support", "Operations",
    "Client Services", "Client Services",
    "Sport", "Client Services",
    "Creative", "Creative Services",
    "Creative Production", "Creative Services",
    "Delivery", "Creative Services",
    "Design", "Creative Services",
    "Editorial", "Creative Services",
    "Finance", "Operations",
    "IT", "Operations",
    "Legal", "Operations",
    "Marcomms", "Operations",
    "New Business", "Operations",
    "Paid Media", "Planning",
    "People and Culture", "Operations",
    "People & Culture", "Operations",
    "Production", "Creative Services",
    "Research & Insights", "Planning",
    "Senior Management", "Leadership",
    "Strategy", "Planning",
    "Tech/Development", "Creative Services",
    NULL
)

直接使用这个格式化后的版本即可，避免隐藏字符或换行导致的解析问题。

场景2：在标准SQL环境（MySQL、PostgreSQL、SQL Server等）中使用 #

标准SQL不支持这种参数式的CASE写法，必须改用CASE ... WHEN ... THEN ... ELSE ... END的标准语法，否则解析器会因无法识别语法结构报错：

CASE Department_Text__c
    WHEN "Administration" THEN "Operations"
    WHEN "Support" THEN "Operations"
    WHEN "Client Services" THEN "Client Services"
    WHEN "Sport" THEN "Client Services"
    WHEN "Creative" THEN "Creative Services"
    WHEN "Creative Production" THEN "Creative Services"
    WHEN "Delivery" THEN "Creative Services"
    WHEN "Design" THEN "Creative Services"
    WHEN "Editorial" THEN "Creative Services"
    WHEN "Finance" THEN "Operations"
    WHEN "IT" THEN "Operations"
    WHEN "Legal" THEN "Operations"
    WHEN "Marcomms" THEN "Operations"
    WHEN "New Business" THEN "Operations"
    WHEN "Paid Media" THEN "Planning"
    WHEN "People and Culture" THEN "Operations"
    WHEN "People & Culture" THEN "Operations"
    WHEN "Production" THEN "Creative Services"
    WHEN "Research & Insights" THEN "Planning"
    WHEN "Senior Management" THEN "Leadership"
    WHEN "Strategy" THEN "Planning"
    WHEN "Tech/Development" THEN "Creative Services"
    ELSE NULL
END

内容的提问来源于stack exchange，提问作者PipRon7