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.
October 5, 2011 7:12 PM
March 31, 2012 12:35 AM