Select * From test Where filename like '%^_abc%.txt' escape '^'The above Select statement works fine in SQL 2005 getting only the 1st row (1234_abcd.txt). It looks like the escape clause is not supported in VFP so how can I do this is VFP 9.0?
Table: test idtest int filename varchar(50) Data: idtest filename ------ -------- 1 1234_abcd.txt 2 5678xabc2.txtSarosh