Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    21

    Exclamation Unanswered: line feed character

    Hi,
    does anyone know what is the representation of line feed character in tsql?
    I have a field

    ' i need
    to change
    as following'

    that, when i select. must look like
    '' i need to change as following'


    thank you all in advance for your help.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    select str_replace(a,char(10),null)a1, str_replace(a,'
    ','')a2
    from (
    select 'i need
    to change
    as following'a
    )t

Posting Permissions

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