Post reply

newbie - how to get newline in varchar(MAX)?

  • April 24, 2007 at 5:38 am

    #177528

    is this forum willing to accept newbie questions? if not, please let me know

    for the moment I am trying to get multiple lines into a varchar(MAX) column - in Access it was a Memo column and CTRL ENTER to get on with it

    in SQL Server when I cut&paste I get only up to the first newline

    help will be appreciated

  • April 24, 2007 at 1:59 pm

    #702254

    Try to use char(13) + char(10), here is example:

    create table test

    (data varchar(max))

    insert into test

    values ('hello ' + char(13) + char(10) + 'world ! ')

    select * from test

    Is this what you need ?

     

     

  • April 24, 2007 at 2:06 pm

    #702257

    not really ... I was looking for an interactive mode to enter lines into a field - actually I am using this table for notes and questions on SQL Server as I learn it - this was a trick that worked well in Access, but appears that I simply cannot do it in SQL Server without an Application (you can't get there from here, as the eskimo said to the scotsman)

     🙂

    I will have to go back to using Notepad

    thanks anyway

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply