SQL Server Stored Procedure

• Rajeev Khare

  SSC Veteran

  Points: 206

  More actions

  April 27, 2004 at 1:33 am

  #152120

  hello all

  can anyone tell me how to write a stored procedure to find out newline char in a specific field in a table of sql server database and eliminate this.

• AH

  SSC Veteran

  Points: 267

  More actions

  April 27, 2004 at 2:39 am

  #504295

  Try this ..... char(10) - Line Feed / char(13) - CR

  SET NOCOUNT ON

  go

  drop table #NEWLINE

  go

  create table #NEWLINE (Field1 int identity(1,1), Field2 varchar(30))

  go

  insert #NEWLINE select '1111

  11111'        

  go

  select * from #NEWLINE

  go

  update nl

  set nl.Field2 = replace(nl.Field2,char(13), ' ')

  FROM #NEWLINE nl

  update nl

  set nl.Field2 = replace(nl.Field2,char(10), ' ')

  FROM #NEWLINE nl

  go

  select * from #NEWLINE