REMOVENULL(string_exp)

Replaces all embedded binary zeros in a string with spaces.

 

Example:

 removenull('abcde'+chr(0)+'moretext') returns 'abcde moretext' - where the binary zero has been replaced with a space