>>Are there any strategies that will allow for working around the 255 character limitation in VFP ODBC on SQL Updates? If not, are there alternative solutions to this dilemma.
>>
>>Thanks in advance.
>>
>>Matt
>
>Can you create a stored procedure on SQL Server and call the sp?

Thanks for the reply! I will check into this. I was considering using OLE DB to access a SQL Server backend but don't really have the time to devote to this without being sure if this is a viable solution around the 255 character limitation. For background, I am trying to allow updates to db fields in VFP (but would be willing/able to upsize to SQL Server) from a web-based front end.

Thanks again.
Matt