Escape sql

Table of Contents Syntax Description Examples See Also

Syntax

• escape_sql(<value></value>);

Description

Converts the value to a string and escapes special characters so that it's safe to use in query_sql(). Returns the escaped form of the given value.

Examples

set .@str$, "John's Laptop"; set .@esc_str$, escape_sql(.@name$); // Escaped string: John\'s Laptop

See Also

• query_sql

Category:Script Command