I'm trying to search a field for a specific word. The word is "son". This field contains a lot of names and I've found it difficult to isolate the records that only the exact word, son. I've been using the CONTAINS function with " son" and " son " but I pick up out unusual names like sonny, in the first case, or I lose records that end with son. (no spaces after son)
Side question: Is it possible to have multiple conditions CONTAINS. For example (syntax incorrect):
CONTAINS_IC(#family;"son" OR "daughter")
Please sign in to leave a comment.