SQL - LIKE statement

[raj]

Thanx a lot Sean and Glenn, it works
One more ques:
what if i need all the records by date field????
e.g . if i need all the records with date > 1/1/99...
then what would SQL be like....

Select * from Details where date > "1/1/99"

this one above doesn't works........
if u know how, please let me know.....
thanx again for ur time...
Raj

[LG]

The date field in sql statement should be surrounded by # not ".
Select * from Details where field_name > #1/1/99#

[raj]

It still gives me error:

[Microsoft][odbc Visual foxpro driver]Missing operand.

Any ideas???? thanx

[LG]

Try this:
Select * from Details where field_name > #1/1/99#;

Add ; at the end of the statement.