ansaurus

Question

Answer 1

+2 A:

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

Joel Coehoorn 2009-07-17 14:19:03

You need to give a length for nvarchar, else you can truncate the data (defaults to 30 if not specified like this!)

AdaTheDev 2009-07-17 14:22:44

To do that, I'd need to know the length of the nChar column.

Joel Coehoorn 2009-07-17 15:02:19

I see. Thank you very much.

Joe Flateau 2009-07-17 16:26:53

Answer 2

+4 A:

declare @foo nchar(32)
select @foo = '   Hello, World   '
select ltrim(rtrim(convert(nvarchar(32), @foo)))

Adamski 2009-07-17 14:21:43

Convert nchar column to nvarchar and Trim whitespace