select count(*) from test where a like '%'||chr(10)||'%'; select count(*) from test where a like '%'||chr(13)||'%';