Hi,

> Is there a function that would search the string for multiple occurance of a variable and replace it with null?

By NULL do you mean "0" or CHR(0)? If the latter adjust the suggested solutions accordingly....

Regards,
Viv