Hey Guys,

 

I have a list of UUIDS all separated via a carriage return. I'm using a where IN clause in my execute SQL and understand that if I want to put my values in the IN then I need to remove the carriage returns and surround each value with a quote mark.

 

Does anyone already have a standard way of doing this or a custom function already available they can point me towards.

 

Thanks

Jalz

Does anyone already have a standard way of doing this 

 

Try

ExecuteSQL ( "
  …
  WHERE someField IN ('" & Substitute ( listOfUUIDs ; ¶ ; "','" ) & "')
  " ; "" ; ""
)

Note the two singles quotes, just after the opening and before the closing parenthesis.

http://filemakerhacks.com/2012/05/21/fm-12-executesql-robust-coding-part-2/