ESCAPE Sequence in Teradata

Teradata uses ' (single quote) as escape sequence character. Escape sequence is necessary to print a single quote character.

Example
SELECT 'Adam''s Apple'

Note : single quote followed by single quot escapes the second single quote character.

Output:
Adam's Apple