To join 2 columns in same table

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???


  • select distinct Convert(varchar, rrquarter) + ', ' + Convert(varchar, rrfinyear) as Quarter from rreview
Sign In or Register to comment.

Howdy, Stranger!

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


In this Discussion