Add word to value in new column if it exists in another column

[maygross]

What in db formula can I use to add "IoT" at the end of a value name in column "category" if "IoT" exists in a different column. I dont want to create a brand new column, but I want to just alter the current column. I also have a lot of different category values so I would prefer a formula where I dont have to list all of them out and say if Contracted and flag IoT then Contracted IoT. Is there some sort of way I can do this with concat?

current data:

Flag	Category
other	Contracted
IoT	Contracted
IoT	COAM
other	COAM
other	Expired

desired outcome:

Flag	Category
other	Contracted
IoT	Contracted IoT
IoT	COAM IoT
other	COAM
other	Expired

[TimN]

Here's a way with a simple if statement.  You prefer no if?