Updateing a text column

[stiej]

Hello, i cant seem to find a previous post that covers my particular issue. Here's the problem.

I have a table, it contains a column (MyText) of text datatype.

Using a stored procedure, I want to update the value in MyText (for a given id) to a value stored in a variable.

how would you do this? using the writetext function.

Thanks in advance for any help...

 

[mrdenny]

Using the UPDATETEXT function.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com