Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Concatanete new line

    I need to store data in XML format in the database. When the data is retrieved and printed onto a file, say, it should be automatically printed in a file format i.e. each seperate line on a new line. How can this be done? Can we append a newline character to each line before storing it as a record in the database?/If so, how can this be done?

    Thanks in advance

  2. #2
    Join Date
    Apr 2003
    SC, USA
    You can add a Carriage Return and Line Feed to a string as follows:

    'your string' + CHAR(13) + CHAR(10)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts