jaysayers

SQL function to remove spaces between words

Discussion created by jaysayers on Sep 11, 2014
Latest reply on Sep 21, 2014 by beverly

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

 

Example:

 

Student NameGrade
Jay Sayers9
Steve Jobs4
Salma Hayek12

 

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!

Outcomes