> >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\_%'