Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQLSERVER > Removendo quebra de linha de um Varchar
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) ,' ')
@ghost

This comment has been minimized.

Copy link

ghost commented Feb 14, 2017

👍

@mustangGuns

This comment has been minimized.

Copy link

mustangGuns commented Oct 25, 2017

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

@DenisJesusBatista

This comment has been minimized.

Copy link

DenisJesusBatista commented Sep 13, 2019

Valeu pela dica!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.