Home Forums SQL Server 2008 T-SQL (SS2K8) how to remove characters char(0) to char(31) RE: how to remove characters char(0) to char(31)

  • November 16, 2012 at 6:43 am

    #1559780

    something like this may work for your purpose, but I think that may depend on

    SELECT REPLACE(REPLACE(yourfield, CHAR(13), ''), CHAR(10), '')

    This basically replaces the char with nothing.