SetQueryConditionLike ( _datafield ; _condition ; _orchar ; _andchar ; _leadingWC )
Generate SQL WHERE-conditions for a string of (multiple) value(s)
Be the first to rate this function Log in to vote
Otmar Kramis - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Builds a WHERE-condition LIKE string for a SQL field and a search string containing search values delimited by OR-character or/and AND-character. Parameter 3-5 can be empty, defaulting to "," for OR, "&" for AND and no leading wildcard (%). The asterix "*" is handled as SQL wildcard.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.