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