Convert nchar column to nvarchar and Trim whitespace

Question

Could someone please help me with this?

I need to convert an nchar column to an nvarchar column and trim the whitespace.

Thank you.

Answer 1

SELECT RTrim(CAST([MynCharColumn] As nVarChar))