>Hay, it worked, even in VFP
>
>SELECT * FROM test WHERE LIKE("c:\test1\*",LOWER(test))
>
Greg,
lower(Test) LIKE 'c:\test1\_%'
is optimizable (if you have index on LOWER(Test).
The second one is not :o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.