How Do I insert a Carriage Return in a String?

Hi.

  I would like to know How I can Insert a Carrige return in a string that will ultimately end up in a large VARCHAR2

Here is an Exemple:

  FIELD1|| 'CR LF'||FIELD2   'CR LF' Should =be a Line Feed - carriage Retrun...

Thanks. Received on Mon Oct 19 1998 - 14:25:21 CDT