Home > IT Answers > Development > Concatenating two note fields into one, but need them to be on their own line
Macsterling
5 pts.
 Concatenating two note fields into one, but need them to be on their own line
Carriage Return Line Feed, Concatenate, CRLF, CRLF SQL2005, SQL, SQL Server 2005
sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

Software/Hardware used:
ASKED: January 13, 2009  3:28 AM
UPDATED: January 13, 2009  1:51 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _