Reducing Data type Lenght

[mahendra dubey]

Hi There
I m using sql server. I have a column Name nvarchar(max) in table.Now I want to change datatype nvarchar(max) to nvarchar(4000). Will the data be truncated automatically?
if 'Yes',How data will be truncated. i.e. from left ,from right or any part.

Is this truncation depends on Sql server version also?
Awaiting Your response

[ssnaik84]

Now I want to change datatype nvarchar(max) to nvarchar(4000).

why do you want this change??

For SQL SERVER,
nvarchar(max) == nvarchar(4000)
varchar(max) == varchar(8000)

[nbiswas]

Yes there will be data truncation from right to left