AnsweredAssumed Answered

ExecuteSQL with IN

Question asked by DavidZakary on Apr 5, 2017
Latest reply on Apr 6, 2017 by fmpdude

Having issues with an ExecuteSQL statement.


I have a user created list of keywords. I need to find the keywords in another table which will have a short description and a numeric value. I need to search the description for the keywords and return both the numeric value and the description.


I can't seem to get the WHERE clause with IN working properly.


ExecuteSQL ( "

     SELECT nc_class, nc_class_description

     FROM NICE_data

     WHERE currently_pulling_hair_out IN frustration




keyword )


What would the proper WHERE statement be?