Thanks for responding. I was talking about needing to update a literal text string of 7,200 characters and it couldn't be done either by assigning the literal text string to a variable declared in Query Analyzer to by imbedding the literal string in an update statement. Andrew Coates cleared it up for me by showing me the syntax of a SQLEXEC statement that can be run with parameters from VFP. I wasn't aware you could do that and that solved the problem.
Bill
>128 characters is the maximum length of an identifier. Do you have a column name that is 128 characters?
>
>I'm confused by your problem. You have data in a text column that you want to update. You can use UPDATE. You can also use ADO with the new Stream object (introduced in 2.5).
>
>-Mike
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!