CASE statement in query table over 100 characters for column length

CASE statement in query table over 100 characters for column length

I've been working my way through the forums getting a ton of insight, so thanks for that. But I can't seem to find an answer to this issue. When I create a CASE statement to bundle different accounts together, I can't get the column name length down to 100 characters. Is there a way to get around that? Here's my example:

SELECT "Account Name",
CASE
WHEN "Account Name" LIKE '%foo%' THEN 'A'
WHEN "Account Name" LIKE '%bar%' THEN 'B'
ELSE 'C'
END
FROM "Accounts"

This example might be below 100 characters, but my search strings are slightly longer and I'd like to add a few more categories.

And this actually brings up a secondary question where perhaps there's an easier way to create categorizations in a custom Zoho Reports column somehow. It would have to be dynamic so that it's always up to date, and this is something I don't want to put on the CRM side because it's too report-specific.

Any thoughts you have on either of these parts would be greatly helpful! Thanks.