SQL Server: string concatenation fails with some data types

Description

Need to cast to nvarchar(max) on each side of concatenation to get results.

Environment

None
Fixed

Assignee

Unassigned

Reporter

Dominic Watson

Accepted

Yes