>
>If I use ODBC ( the one that isn't sql native client ) when I create the ODBC connection, everything works without casting. But SQL Native Client seems to either have a bug or an 'undocumented feature' <s>
>
>So this is known behavior of SPT and varchar(max) and SQL Native Client?
>
>Is it documented or mentioned anywhere? Sure made me crazy trying to figure out why some my views worked and some didn't in retrieving memo data.
>
I documented it on forums for a few times at least:) I noticed the dicrepencies first with XML datatype, then OLEDB driver and passing byte arrays from .Net (now in list of corrected bugs of SP2-but I don't use SP2) then varchar(max). Bug seems to be within VFP not the driver itself. Try with a nonVFP environment and it correctly returns the data.
Cetin