Replaces characters in a string with a single character or no character. REPLACECHR searches the input string for the characters you specify and replaces all occurrences of all characters with the new character you specify.

Syntax

REPLACECHR( CaseFlag , InputString , OldCharSet , NewChar )

Example

REPLACECHR(0 , IN_PHONE , 'abcdefghijklmnopqrstuvwxyz!@#$%^&*(1234567890' , NULL)

0 - represents non case sensitive , 1 represents case sensitive.