Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 SQL for Foxpro Driver

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-02 : 09:10:21
Dan writes "I seem to be having trouble finding a way to search for string fragments within Foxpro (Open Directory Database) table cells.

I have always used this for Access and SQL DB's in the past:

Select * From MyTable
Where instr(FieldName, '"&request.querystring("value")&"');

However, Foxpro doesn't like 'instr'

Any ideas?"
   

- Advertisement -