Showing two char fields columns as one

Question

Post reply

Showing two char fields columns as one

bids.server

Grasshopper

Points: 12
More actions
November 2, 2010 at 7:56 pm

#228588

HI frnds,
I need to combine two character fields columns as one..plz help me

Viewing 3 posts - 1 through 3 (of 3 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

In the query that retrieves the data, just concatenate them together:

SELECT CombinedColumn = StringCol1 + StringCol2

FROM YourTable;

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

If you can't touch or modify your query, you can concatenate the fields using the expression builder in SSRS.