Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    28

    Unanswered: inserting newline as data

    I want to insert a newline character into a VARCHAR(254) type column along with other varchars for testing (from the Command Center). How do I do this?

    The column has to contain, for instance, this:

    abcd '\n'
    wxyz

    Thanks for any help.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    insert into mytable (myfield) values ('abcd' || chr(13) || 'wxyz')

  3. #3
    Join Date
    Jun 2004
    Posts
    28
    Thanks, ni!

Posting Permissions

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