Hi!

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?

I basically want to specify that the '_' (underscore) character mentioned in the like string should be treated as a literal and not as a wildcard character.

Table: test
idtest int
filename varchar(50)

Data:
idtest  filename
------  --------
1       1234_abcd.txt
2       5678xabc2.txt

Sarosh