Stuff Function & NText

[oddball]

Have a 'Description' Column in my SQL7 DB which is currently NVarchar (4000). Need to change the data type to allow more characters. NText seemed to be the way to go, but it causes errors saying that its not a valid selection for Argument 1 of the Stuff function (I thought the stuff function worked with character data types which NText is).

How can i fix this?

cheers,

si

 

[JohnDTampaBay]

NText is handled like the image binary datatype. You will use READTEXT and WRITETEXT to access the data. The N specifics a Unicode datatype, which means each character is going to cost 2 bytes in storage space rather than 1 byte each. IMHO, I would avoid NText and Text if at all possible. It is more trouble than its worth to fight with them. --Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
0 row(s) selected