TO_NVARCHAR

The Converts a given value to an NVARCHAR data type, with an option to format the output value.

Syntax

TO_NVARCHAR(<value> [, <format>])

Example

SELECT
TO_NVARCHAR(mycolumn, 4000)

This returns:

results in column of nvarchar(4000)