Detecting and Handling Non-Printable Characters in DB2 SQL Using LOCATE() and REPLACE() Functions Aldo SUCCI

​[[{“value”:”Non-printable characters can sneak into our records for various reasons, and to prevent issues, we can run an SQL query that uses the LOCATE() function.
This query uses the REPLACE function to substitute the non-printable characters ‘0D’ (Carriage Return) and ’25’ (Line Feed) with a blank space in the CLNOM0 field.”}]] Read More 

Verified by MonsterInsights