if text contains then

[civileng]

I have a querie that contains column1 with text(description of incident maybe weather info). I would like to create new column which would search throug column1 and then insert certain word into this new column if searh is sucessful. For example if column 1 contains word snow then snow if colum1 contains word foggy then fog.

colum1................ ..........newcolumn
crash reason snow... ......snow
slow traffic, foggy ..........fog



What is the simplest way to solve this problem?

[Rawb]

The best way would probably be with a custom VBA function that takes colum1 as an argument and returns "snow", "fog", etc. Then you can just call that function from inside your Query.