MoneyWorks Manual
Edit
Esc (text)
Result Type: String
Definition: Returns a string that has any string quotes or backslashes in the input string escaped with \.
Use this function when building a search string that incorporates quoted data from the database or other user input that may itself contain quotes or backslashes. If these characters are not escaped when constructing a search string, the search will fail with a syntax error.
Examples:
Esc("a backquote ` character")
returns "a backquote \` character"
CreateSelection("account", "code = `" + Esc(userVal) + "`")
This sanitises userVal in case it contains a backquote or backslash character.