Don't have Telegram yet? Try it now!
https://scientiacompendium.blog/2018/04/19/netezza-puredata-how-to-replace-or-trim-char0-is-null-characters-in-a-field/
Netezza / Puredata – How to replace or trim CHAR(0) is NULL characters in a field