SQL 2005我可以在case语句中使用关键字

I need a case statement that allows partial matches. I get a syntax error, but am wondering if anything similar to this is possible. If not, my secondary solution is to re-write as a cursor... Example:I need a case statement that allows partial mat