Sorry, I'm not seeing where my syntax is incorrect on this simple query:
WHEN LIKE 'group%' THEN GroupItem
WHEN LIKE 'trade%' THEN TradeItem
END AS ItemType,
SUM(curPrice) AS Total
GROUP BY strMerchItemName
But I'm getting the following error:
"Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'LIKE'."
I don't see what's wrong with my CASE statement and the LIKE statements. Can somebody please show me where I'm making my mistake(s)?