[MS SQL] Replace Value

 

  UPDATE [dbo].[SOME_TABLE_NAME]
  SET 
      [SOME_FIELD_NAME] = REPLACE(REPLACE([SOME_FIELD_NAME], CHAR(13), ''), CHAR(10), '');

 

 

행복한 고수되셔요.

woojja ))*

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\