We have a SharePoint 2013 list that stores a list of work hazards. One of the columns is called "Hazard" and contains words which relate to the type of hazard it is.
Two Examples of data in the Hazard column are:
"Cross country line patrol / physical injury"
or
"Stringing conductor with stringing equipment / approach road / road /driveway / crossing / physical injury"
In SharePoint, this column is a single line of text. Notice the above two examples have the words "cross" in them.
My question is, how can I create a CAML query to return both results if a user was to search based on the Hazard column for "Cross Country". If I use "contains", it only returns the first example, not the second.
Thanks in advance.