Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unanswered: How to insert a break line ?

    Hi,
    I just want to insert a break line in a char(200) datafield with a simple insert/update query :
    update toto set my_txt="My title.Insert a breakline here. My txt."
    where ...

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: How to insert a break line ?

    Originally posted by Ericq
    Hi,
    I just want to insert a break line in a char(200) datafield with a simple insert/update query :
    update toto set my_txt="My title.Insert a breakline here. My txt."
    where ...

    Thanks in advance.
    Hi,
    Yuo want to insert a break into the databse or in a flat file ?

    With update, would can you try to arm variables with the first 199
    characters, to concatenate the wished character to him and to
    concatenate the rest to him of string.

    With a flat file can yuo then awk for the change.

    Gustavo.

Posting Permissions

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