Unanswered: sql query for special characters in a field
In a text field in my 9.4.HC4 informix db I have newline characters for some records. Do you know the correct sql query in order to selecet these rows?
I have tried sth like the following but it did not work:
SELECT info-comment FROM info WHERE info-comment LIKE '% || CAST(x'0D0A' as CHAR) || %'