>> >>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:\") >> >>SELECT * FROM test WHERE test > "C:\test1\" >>? _tally >>SELECT * FROM test WHERE (test+'') > "C:\test1\" >>? _tally >>SELECT * FROM test WHERE alltrim(test) > "C:\test1\" >>? _tally >>SELECT * FROM test WHERE cast(test as char(240)) > "C:\test1\" >>? _tally >> >>>>
lower(Test) LIKE 'c:\test1\_%'Hay, it worked, even in VFP
SELECT * FROM test WHERE LIKE("c:\test1\*",LOWER(test))