I'll try that again, because I got the details of the query slightly wrong:

We are writing a client/server application with VFP 6.0 on the front end and SQL Server on the back end.

We'd like to construct a query to send via ODBC which would be equivalent to the following VFP code:

Select * from mytable where mytextvar $ upper(mymemofield)

On the backend, mymemofield is of type TEXT.

We came up with the following:

Select * from mytable where ;
{fn ucase(mymemofield)} ;
LIKE "'%" + mytextvar +"%'"

I'm not at the office at the moment, so I don't have the precise error message, but it's something to do with trying to convert the data type to VARCHAR.

Anyone out there had this problem before ?

Best.