Concatenate 2 columns if different data type

How can i concatenate two columns if one column contains int data type and other one contains varchar data type.

  Devbrat Tripathi


Need to use cast to covert the int data type into text based data type:

Select cast( 1column name as Varchar(20) ) ' ' + 2 column name as new column name

  Awdesh kumar pal       21 Feb 2017       1       0     

Thanks for the answer.. 

  Devbrat Tripathi       05 Mar 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any