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

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 alltrim(test) LIKE "C:\test1\_%" INTO CURSOR aaa
? _tally
BROWSE NORMAL