>>> >>>CREATE CURSOR test (test M) >>> >>>INSERT INTO test VALUES ("C:\test1\test2\") >>>INSERT INTO test VALUES ("C:\test1\") >>>INSERT INTO test VALUES ("C:\test1\test3\") >>>INSERT INTO test VALUES ("C:\") >>The work around is simple - use LIKE command. <pre>lower(Test) LIKE 'c:\test1\_%'>
>SELECT * FROM test WHERE LIKE("c:\test1\*",LOWER(test)) >Use the first version (SQL Server like) so the syntax will be uniform. Don't use VFP specific functions/syntax when more ANSI way is available.