STR ESCAPE()

Purpose

Function to return a string where certain characters or strings have been escaped out or removed

Syntax

STR_ESCAPE(<expC>)

See Also

ASC(), AT(), ATNEXT(), CHR(), CHRTRAN(), DECODE(), ENCODE(), HTML_ENTITIES(), HTML_ENTITY_DECODE(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), STR(), STR_ESCAPE(), STR_REPLACE(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The STR_ESCAPE() function will search <expC> and return a string where certain characters or strings have been escaped out or removed.

• Single quotes are escaped out as to enable embedding within strings
• Embedded SQL statements are disallowed to prevent SQL injection attacks

Example

? str_escape("Grocer's apostrophe")
Grocer''s apostrophe