Although your question is not clear, the error in you query was unwanted
"as Support" in between the
case when statement.
syntactically corrected query is-
case when Business_Group like '%Back Office%' then bonus else bonus end as ALC
But this is something you never want as result, what I believe. Your logic should be
--if Business_Group contains text like 'Back Office' then return bonus in result as ALC
--if not then return different result for result column ALC
Make sure that you understand "case when..." correctly.
Reference:
CASE in SQL Server[
^]
Hope, it helps :)
UPDATE
As per the comment by OP, the solution query should look like-
select case when Business_Group like '%Back Office%' then bonus else NULL end as Support,case when Business_Group like '%Back Office%' then NULL else bonus end as ALC
I beleive there can be a better way to do this but as you wanted the solution using "case when..", this can help.
Please let me know if it doesn't help.