Sql Server Programming :: Assignment in text data type in sql server 2000


	Assignment in text data type in sql server 2000 Hi all, can any one tell me how to assign null value to text data type? any help will be truely appreciated. > can any one tell me how to assign null value to text data type? You should be able to set the value to NULL as you would a column of any data type: UPDATE dbo.MyTable SET MyTextColumn = NULL WHERE MyPK = 1 -- Hope this helps. Dan Guzman SQL Server MVP "Archana" <trialproduct2@yahoo.com> wrote in message news:1173099316.568125.269020@64g2000cwx.googlegroups.com... - Hide quoted text - > Hi all, > can any one tell me how to assign null value to text data type? > any help will be truely appreciated. Hi thanks for your reply. I don't want to update text column of table. I have one stored procedure with has text data type as output paramter. I want to set null value for this. If i can't set null value then what operations i can perform with text data type which passed to stored procedure as output parameter. thanks in advance.