>>>What do you mean by queries against VARCHAR(max)? I use this type of column and SQL Select from my VFP SP2 application with WHERE clause. What am I missing?
>
>Are you using the classic SQL Server ODBC driver? The classic driver predates VARCHAR and fortuitously gets VARCHAR(max) right but has other issues. Newer Native Client drivers on many Windows installs, return a C(0).
Yes, I am using the SQL Server ODBC driver. I will keep in mind not to have the customers update to the Native Client because I have not found any issues with the ODBC driver.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
