Delete Carriage Return
-
How do I delete a carriage return () in SQL Server 2000? I am importing file from a UNIX box and for some reason I have to import it into Access to remove then re-import into SQL Server. Is there a replace statement that will take care of this?
-
How do I delete a carriage return () in SQL Server 2000? I am importing file from a UNIX box and for some reason I have to import it into Access to remove then re-import into SQL Server. Is there a replace statement that will take care of this?
SQL Server Books Online REPLACE Replaces all occurrences of the second given string expression in the first string expression with a third expression. Syntax REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' ) Arguments 'string_expression1' Is the string expression to be searched. string_expression1 can be of character or binary data. 'string_expression2' Is the string expression to try to find. string_expression2 can be of character or binary data. 'string_expression3' Is the replacement string expression string_expression3 can be of character or binary data.
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters