>>>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:\")

>>The work around is simple - use LIKE command. <pre>lower(Test) LIKE 'c:\test1\_%'

>
>Hay, it worked, even in VFP
>

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