SQL Column and Data size

[chester27]

Hi

How do I truncate the length of a data entry in a column. Column set to nvarchar (20) but column for import in set to MAX. I want to import these records but truncate them to max of 20 for that column only.

 

[Crowley16]

cast(columnNams as nvarchar(20))

--------------------
Procrastinate Now!

 

[PRPhx]

And is the data your importing always 20 characters or less?? Or do you not care about the rest of the data?
Do you have any control over the imported data? If you do, I would say to whom ever, please limit whatever field to nvarchar(2).

 

[djj55]

I may be misunderstanding but LEFT(incoming, 20) might work.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!