I need to combine these SELECT statements; May be CASE or IIF can be use;

SELECT Family, Genus, Species, Climaticzone
FROM Main
WHERE Climaticzone Like '*W*';

SELECT Family, Genus, Species, Climaticzone,
Switch(Main.Climaticzone='WI','Wet zone') AS Climate
FROM Main;

In my database there is a column 4 climatic zones. Climatic zone of a plant can be added as any combination of W, I and D
(W, I, D, ID, WI, WID ..)
W=wet


I = intermediate
D=Dry

I know this can be done using switch function easily, but when it comes to more complex combination of colors it will be difficult.
What I want is,
When letter "W" present in a cell as any combination (W, WI, IW, DW, WID, DWI, etc. ...) I have to display Wet zone using switch function,
CASE function my be easy than this I'm new to Access and SQL.
Pls help,