Introducing Radical.sh

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

Search for single quote in Informatica

To search for single code use CHR(39) to get a single quote character and pass the same to INSTR function
INSTR(port,CHR(39))

portoutput
Informatica0
An Information0
I'am2