>>Here one that got me last weekend.
>>
>>All four methods of comparing a Memo field to a string resulted in 0 rows. (notice I was using a greater-then operator.)
>>
>>

>>
>>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
>>
>>

>>
>>The example came from trying to get a list of folder names that are subfolder of a some root folder.
>>
>>Does anyone know of any work-around?
>>I have one but it is slower then expected.
>
>The work around is simple - use LIKE command.

lower(Test) LIKE 'c:\test1\_%'

Hay, it worked, even in VFP

SELECT * FROM test WHERE LIKE("c:\test1\*",LOWER(test))