I have a column called Profile in a table and I am searching for a
specific word in that column. I use the keyword LIKE with the wildcard
(%) and that is working fine, but how do I have the query only return
that word and not all the text in the Profile column. For example, if an
entry in Profile was 'Have you seen my dog', how do I just have the
query return dog (the word I'm looking for) and not the whole statement.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!