Lightspeed Interview Question

How to find if a specific word is in a certain field in SQL?