I have an SQL update statement that I need to run in order to populate a udf. THis is a one time update that I first tested in SQL2000, where it worked correctly. In SQL2005 it does not work. The code is:
UPDATE inv1
SET U_subdesc = ''
FROM inv1 T0 INNER JOIN
OITM t1 ON t0.itemcode = t1.itemcode
WHERE t1.itmsgrpcod <> 106
It is designed to simply blank the text in the udf for items not in the items group 106. In SQL2005, this statement blanks all the udf records. The only clue i have is that the field type changes from nvarchar in SQL2000 to nvarchar(MAX) in SQL2005. How would this statement get formatted in SQL2005 to operate correctly?
Thanks