Archives of the TeradataForum

Message Posted: Sun, 30 Dec 2012 @ 16:17:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

A carriage return character is hex code x'0D', so:

     SELECT *
     FROM   MyTable
     WHERE  MyCharCol LIKE '%' || x'0D' || '%'

Happy New Year,

Bob

	<Prev	Next>		<<First	<Prev	Next>	Last>>