I know it is a little early for Scripting week but I cannot wait. This one has me stumped.
I need to find exact matches for search terms within a string. EG "cat" will find cat but not catastrophe from within a large string.
I cannot use "=" as that would match the whole string and I only want to find the exact match within the string.
Can anyone help me with the syntax here? I have racked my brains coming up with all sorts of convoluted solutions that all end up having a flaw. I have been looking around forum and it seems a few people are asking the same question but getting no answers. (you might see my question in some of them...) I am sure there must be some operator within sql as there is in FMP but I cannot find it.