Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Escape single quote or How to print single quote in Informatica

String literals can contain any character except single-quotation mark. So the following string is valid

Invalid

'Adam's Apple'

Valid : Use CHR function and concatenation operator

'Adam'||CHR(39)||'s Apple'

Note : Informatica does not support escape sequence characters

Tags for Escape single quote or How to print single quote in Informatica

Contribute to Forget Code, help others. Add snippet