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
Latest Marketing Cloud Developer Dumps Valid Version with 141 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments