select *
from HH.MY_TABLE
where TEXT_X like '%' || chr(13) || chr(10) || '%' ... or ...
select *
from HH.MY_TABLE
where TEXT_X like '%' || chr(10) || '%' ... or ...
select *
from HH.MY_TABLE
where TEXT_X like '%' || chr(13) || '%'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 don't link to anything I don't use myself.