Editor's Note: Send your SQL Server questions and comments to SQL Server MVP Brian Moran at savvy@sqlmag.com.
I have a Comments field in a customer service database that captures the data our telephone representatives type. The representatives often press the Enter key as they type, so the comments have many carriage returns. Can I strip the carriage returns to clean things up for a data transfer process that I run?
T-SQL ...