Cannot resolve collation conflict for column 1 in SELECT statement.
Cannot resolve collation conflict for column 1 in SELECT statement.
when concatenate more than two columns in SQL server then this error got
to check collation of column run query
sp_help tablename
to solve this issue keep collation of all concatenate columns as same