How to identify Carriage Returns in HP Vertica

In this short post we will see how to identify Carriage Returns in a column in HP Vertica.

SELECT col FROM   table WHERE regexp_like(trim(col), '[[:space:]]$');