Post reply

New line character

  • June 18, 2008 at 2:55 pm

    #91985

    I have text in a description field which has a new line charecter which is causing the value from the column being displayed in 2 lines

    'Receipt#

    3 generated for the amount of $ 130.00'

    How can replace the new line charecter with blank space ''.

    Any suggestions and inputs would help

    Thanks

  • June 18, 2008 at 2:59 pm

    #830789

    am (6/18/2008)

    I have text in a description field which has a new line charecter which is causing the value from the column being displayed in 2 lines

    'Receipt#

    3 generated for the amount of $ 130.00'

    How can replace the new line charecter with blank space ''.

    Any suggestions and inputs would help

    Thanks

    set @string = 'Receipt#

    3 generated for the amount of $ 130.00'

    set @string = REPLACE(@string ,'CHAR(13),' ')

    Everything you can imagine is real.

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

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