General information
Title:
Implementing $-like Functionality
Hi,
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.
Matt.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only