Find DB2 Fields Containing Carriage Returns, Line Feeds, or Both CRLF

select * 
from HH.MY_TABLE 
where TEXT_X like '%' || chr(13) || chr(10) || '%' </pre>
<p></p>


... or ... 


    select * 
    from HH.MY_TABLE 
    where TEXT_X like '%' || chr(10) || '%' </pre>
    <p></p>
    
    
    ... or ... 
    
    
        select * 
        from HH.MY_TABLE 
        where TEXT_X like '%' || chr(13) || '%'</pre>

Please remember to subscribe to the newsletter or feed to stay up to date.

Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I do not link to anything I do not use myself.