Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate a Field in SQL

Status
Not open for further replies.
RemingtonSteel

RemingtonSteel

Programmer
Jul 14, 2006
65
GB
Hello!

I want to concatenate 2 fields in one field. However, when I save it on the target field I would like to separate the 2 fields (that I will save on the target field) with a carriage return.

Thanks.
Gene
 
Sort by date Sort by votes
It sounds like what you want for the field expression is:

cField1 + CHR(13) + CHR(10) + cField2 AS cYourNewField

Tamar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gabydrdoom
  • Locked
  • Question
Concatenate 2 fields in 1 field with condition
Replies
8
Views
735
GriffMG
GriffMG
SitesMasstec
  • Locked
  • Question
Set a TAG for a field programmaticaly 3
2
Replies
29
Views
2K
SitesMasstec
SitesMasstec
GTGeek88
  • Question
SQL query syntax
Replies
7
Views
148
GTGeek88
GTGeek88
Mukesh Khandelwal
  • Locked
  • Question
Save Chinese + English text in MS Sql table,
Replies
5
Views
613
Chris Miller
Chris Miller
Bryan - Gendev
  • Locked
  • Question
Modifying a character field in a grid to cause an action
Replies
7
Views
285
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top