Adding(merge) two integer columns and make that as a single output column

[phanikumar32]

Hi all,

Can any one please provide me the SQL Query for my following requirement.

As showing in the Figure one i have the Input.
From that Input i want the Output as shown in figure 2.


Thanks In Advance
Phani Kumar.

[jforbes]

You need to let SQL know you want to work with them as string, SQL can be a little dimwitted at times:

SELECT CONVERT(NVARCHAR(5), JoinDate) + '/' + CONVERT(NVARCHAR(5), JoinYear) AS ConcatJoinDate FROM YourTable

[phanikumar32]

Thank you Mr jforbes for your response.