I have a portal filtered by a $variable. The filter runs a pattern count on the $variable . Lets say I have a field that combine first middle and last name.
If the data contains "Jimmy Jones"
Jim, Jimmy or Jones all return the data but "Jim Jones" won't
Is there an easier function to do this like a "Contains"
The actual field has about 10 pieces of information and there is no way to know how many " " the user might enter in to the $variable
Thanks for any help!