Hi,

> I am trying to setup a remote view in VFP as follows:
>
> SELECT * ;
> FROM MLOOKUPS ;
> WHERE MLOOKUPS.CTYPEID = 'NONC' ;
> ORDER BY MLOOKUPS.CLOOKUP
>
> The 'NONC' is actually a partial string. Though no errors are generated I
> do not get any records from the database.
>
> Please advise, how can I WHERE partially matching records.

Well, obviously, the value in CTYPEID <> 'NONC", else
it would have returned rows ;-)

You can use the following:

MLOOKUPS.CTYPEID STARTING WITH 'NONC'

or you can use

MLOOKUPS.CTYPEID LIKE 'NONC%'

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com