How to find next line character in teradata?

@aubrey 

In Teradata SQL, the newline character is represented by the ASCII code 10. To find the next line character in a string, you can use the ASCII function to determine the position of the newline character in the string.

For example, you can use the following SQL query to find the next line character in a string:

1
2

SELECT POSITION(CHAR(10) IN 'This is a string with a newline character
') AS newline_position;

This query will return the position of the newline character in the string 'This is a string with a newline character', which in this case is 29.