Replace enter with space

sql-server-2005 vb.net-2010
Ali picture Ali · Nov 21, 2012 · Viewed 41.6k times · Source

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

Answer

Tim Schmelter picture Tim Schmelter · Nov 21, 2012

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

  • Line Feed – CHAR(10)
  • Carriage Return – CHAR(13)

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),' ');

Related questions

INSERT permission was denied on the object 'employee_info', database 'payroll' schema dbo

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myconnection As SqlConnection Dim mycommand As SqlCommand Dim ra As Integer myconnection = New SqlConnection("server=IAI-004;uid=;pwd=;database=payroll") myconnection.Open() …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More