merge columns

Question

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Looking for something like this?

Select PersonName + ', ' + DogName as FullName from dbo.YourTable

Note that this assumes that you don't have nulls in the table.

Sarah-244562 Newbie Points: 5 More actions · Answer 2

no...I definitly need the dog on the line below the owner.

Is there a write line command or something to make the dog go to the next line?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Select PersonName + Char(13) + char(10) + DogName as FullName from dbo.YourTable

BTW this is something that you should do on the client side, not in the query. It's something very easy to do in vb.

Sarah-244562 Newbie Points: 5 More actions · Answer 4

Newbie

Points: 5

July 8, 2005 at 8:59 am

how would you do that in VB?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

me.txtbox.text = myrs.fields("Field1").value & vbcrlf & myrs.fields("Field2").value

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Or actually put the 2 textbox one above the other .