>In my remote view - I am having trouble updating SQLServer fields of "text" datatype if the data is longer than 255.
>I get an error message telling me to use the "Convert" function. I believe it is referring to an SQLServer function - can I do the equivalent somehow in VFP syntax or with SQL syntax somehow?

Yes that function is in T-SQL, you are getting an ODBC/SQL Server error. Like the memo fields in VFP, text fields in SQL server have to be handled a little differently. In SQL, you cannot have a char variable longer than 255 characters, thus, when it sends the SQL command via ODBC, it chokes. Just code it like you would a memo field, and you should be OK.

HTH,
Scot.