Replace enter with space

Question

How can i replace "Enter" in one of fields in the database with space

actually I have tried the below codes in vb.net, but non of them is working for me ,,

 address = Replace(address, System.Environment.NewLine, " ")

or

address = Replace(address, vbNewLine, " ")

or

address = Replace(address, Chr(13), "")

Language : Vb.net database : MSSQL 2005

Thanks in advance

new lines are \n\r in windows, so try Chr(13) and Chr(10). – user1097489 Nov 21 '12 at 09:33 — user1097489, Nov 21 '12 at 09:33
thank you so much , Chr(10) works – Ali Nov 22 '12 at 06:34 — Ali, Nov 22 '12 at 06:34

score 23 · Accepted Answer · answered Nov 21 '12 at 09:44

If you want to replace new-line chars in SQL-Server.

So if you want to update a column and replace NewLines with white-spaces:

UPDATE TableName SET address=REPLACE(REPLACE(address, CHAR(13),' '), CHAR(10),' ');

score 6 · Answer 2 · answered Sep 03 '14 at 10:32

6

Line Feed – CHAR(10)
Carriage Return – CHAR(13)
Tab char(9)

REPLACE(REPLACE(REPLACE(address, CHAR(13),' '), CHAR(10),' '), CHAR(9),' ')

answered Sep 03 '14 at 10:32

Tanmay Nehete

2 Answers2