> 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
SET MyTextColumn = NULL
WHERE MyPK = 1
Hope this helps.
SQL Server MVP
@yahoo.com> wrote in message
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.