Replace Spaces and New Lines with One SQL Statement
August 2, 2018
2:08 pm
You can replace new lines and spaces inside a field with a statement similar to the following: REPLACE(REPLACE(LTRIM(RTRIM(FIELD_NAME)), CHAR(13), ”), CHAR(10), ”)