Concatenation of 2 columns with string seperater?

  • Thread starter Thread starter What-a-Tool
  • Start date Start date
W

What-a-Tool

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
 
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 said:
dcGame.Expression = "Home + ' ' + Guest"
Click to expand...

Hmmm, did you try: dcGame.Expression = "[Home] + 'vs.' + [Guest]"
Click to expand...
 
Back
Top