Is there an SQL function to remove spaces between words within a column? I have tried the SQL 'REPLACE' function but FileMaker Pro returns the following error:
ExecuteSQL: Error Executing File SQL; FileMaker Error: ERROR: FQL0030/(1:113): "REPLACE" is an invalid function
I want to remove the space between "Steve Jobs" to return "SteveJobs"
Please let me know if I can provide any more information to help clarify the issue.
Thanks in advance!