By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,165 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,165 IT Pros & Developers. It's quick & easy.

Concatenation of 2 columns with string seperater?

P: n/a
Have 2 columns in a DataTable:
Home
Guest

I want to concatenate them into 1 column (A New Data Column) with a "vs."
between them.
I can combine the 2 rows with this format:

dcGame.Expression = "Home + ' ' + Guest"

but I can't get the ".vs" in there no matter what I try.

Could someone please tip me off to the correct formating?

Thanks-Sean
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"What-a-Tool" <Fr***********************@cox.net> wrote in news:e3sbb.2471
$0Z5.252@lakeread03:
dcGame.Expression = "Home + ' ' + Guest"


Hmmm, did you try: dcGame.Expression = "[Home] + 'vs.' + [Guest]"
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 20 '05 #2

P: n/a
You know, I sat here for an hour last night trying what I thought was every
posible combination here. I did try brkts with this statement, and I would
have thought that I had tried this particular combination you suggested, but
evidently not.
It did just what I wanted
Thanks again - Sean
"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .
"What-a-Tool" <Fr***********************@cox.net> wrote in news:e3sbb.2471
$0Z5.252@lakeread03:
dcGame.Expression = "Home + ' ' + Guest"


Hmmm, did you try: dcGame.Expression = "[Home] + 'vs.' + [Guest]"
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.