Dear forum members,
I'm trying to figure out the encoding for a variable's value when using the "WHERE field_name IN ( value1, value2... )" clause. The IN operator allows you to use multiple values in the WHERE clause.
The SQL statement for using the WHERE clause with IN operator is:
WHERE column_name IN (value1,value2,...)
In FileMaker, my function is configured as as:
WHERE field_name IN ( ? )";
" " ; "¶"; $$_variable
The value in the global variable ($$_variable) is a comma delimited text string: "1000", "1100", "1200", "1300" and is passed as a parameter to the ? however this doesn't return the expected results, actually it returns NULL. I know that the arguments in my SQL statement work becasue I can take a single value (e.g., "1000") and plug it into:
WHERE = ? ";
" " ; "¶"; "1000"
returning the correct result.
How should I format the global variable containing my comma delimited value in order to take advantage of the IN operator?
Thank you for your time.