I am trying to find all fields that have specific words in them, standing by themselves. The list of words includes
I would want
132 Beach Road
to show up (Road)
but not 132 Broadside Lane (Broad != road)
What we have now is something like where field LIKE "*ROAD*" which obviously gets too many hits. I cannot figure out how to do word boundaries in Crystal reports. Please help
I don't think the database it is accessing is SQL, but I'm not positive.