Filemaker ExecuteSQL isn't working as expected

Question

I'm using the following line to get the data using ExecuteSQL

ExecuteSQL("SELECT name, Replace(description, '  ', '__') from event");

But it gives the output as ? which means invalid sql in Filemaker. If I try the query like below it is working fine.

ExecuteSQL("SELECT name, description from event");

I don't understand why it is not working. Does Filemaker support Replace function of SQL or any error in the code?

Can someone help.

Answer 1

I believe, "replace" is not supported in Filemaker SQL. I can not find it anywhere in the reference.