ExecuteSQL function syntax for quotes
I have read the documentation provided by FileMaker regarding the ExecuteSQL function. I am having trouble using it in a field calculation as I don't know how to handle the quotes. For instance, if I want to use a SELECT statement in the function, I have to use "SELECT * FROM...." but if in this statement I need a WHERE status = 'Paid' I get an error. Does anyone know the correct syntax for quotes usage?