A developer wants to write a query to compile data originating from an HTML form...

To remove line breaks within the Comments field and replace them with a single space, you can use the REPLACE function in combination with the CHAR function. The CHAR(13) and CHAR(10) functions represent carriage return and line feed characters, respectively.

REPLACE Function: This function is used to replace occurrences of a specified string with another string.

CHAR Function: This function returns the character based on the ASCII code provided.

Example:

SELECT REPLACE(REPLACE(Comments, CHAR(13), ' '), CHAR(10), ' ') AS Comments FROM YourDataExtension

Salesforce SQL Reference