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?

Outcomes