Exam4Training

Which SQL functions could be used to change each line break to a single space?

A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.

Which SQL functions could be used to change each line break to a single space?
A . REPLACE and CHAR
B. FORMAT and SPACE
C. LTRIM and RTRJM
D. REPLICATE and NCHAR

Answer: A

Exit mobile version