scientiacompendium.com
Netezza / Puredata – How to replace or trim CHAR(0) is NULL characters in a field
Occasionally, one runs into the problem of hidden field values breaking join criteria. I have had to clean up bad archive and conversion data with hidden characters serval times over the last…