Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

To join 2 columns in same table

supriyapbsupriyapb Member Posts: 4
How can we join 2 integer columns in same table? We can join columns which have datatype as varchar. i.e.

select distinct rrquarter + ', ' + rrfinyear as Quarter from rreview

This query will display like "Supriya, B" if it is varchar.
Above query works fot varchar data type columns.

But I have integer values in these columns. So, if I run the query it gives me just mathematical addition of both.

Can anyone give the solution for this???

Comments

Sign In or Register to comment.