不能在LIKE关键字附近确定错误吗

I'm running into an error with a sql inquery near my LIKE statement. Am I formatting the LIKE clause incorrectly within the WHEN clause of a CASE? Here is the code.I'm running into an error with a sql inquery ne