Posted by Marc Filthaut on 10/02/27 11:50

Hi,

I have a problem, I have a table with a text type column and a
nvarchar(2000) type column on my MS SQL 2000 Server.

I know that the longest text in the text field is 1000 chars. I want to
copy the content the content of the text field into the nvarchar field.

I tried convert and cast but after the update there are only 255 chars
in the nvarchar field.

Best regards
Marc

• Next in forum: Stored Proc Question : Why If Exisits...Drop...Create Proc?
• Prev in forum: Assistance building a query...
• Thread view: Copy text columns to nvarchar

[Reply to this message]