Home Forums SQL Server 2005 T-SQL (SS2K5) How to remove CrLf from strings in sql RE: How to remove CrLf from strings in sql

  • December 21, 2010 at 12:12 pm

    #1265224

    Try something like:

    REPLACE(REPLACE(column, CHAR(13), ''), CHAR(10), '')

    Of course, CHAR(13) = cr, CHAR(10) = lf

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.