Skip to content

Instantly share code, notes, and snippets.

@roalcantara

roalcantara/gist:4259051

Created December 11, 2012 14:46
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save roalcantara/4259051 to your computer and use it in GitHub Desktop.
Save roalcantara/4259051 to your computer and use it in GitHub Desktop.
Download ZIP
SQLSERVER > Removendo quebra de linha de um Varchar
Raw
gistfile1.sql
DECLARE @STR AS VARCHAR(500)
SET @STR = 'Salvador ·
Terça-feira 10 de abril de 2007 Ano XCI · No 19.383'
SELECT REPLACE(@STR,CHAR(13) + Char(10) ,' ')
Copy link

ghost commented Feb 14, 2017

👍

@mustangGuns
Copy link

SELECT REPLACE(REPLACE(@coluna,CHAR(13) + Char(10) ,' '), CHAR(10), '')

@DenisJesusBatista
Copy link

Valeu pela dica!

@arochaa
Copy link

arochaa commented May 19, 2021

Thx mustangGuns!

@marcospastora1
Copy link

Muito obrigado!!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment