# is the delimiter used by Access.

For SQL, you can use the quote (') like this:

select * from person_registration_details where expiry_date='2002-07-06'

>hello everybody
>i have a problem with vb & sql server7 all the code is working fime but whenever i tried to select a records on the basis of date ,it returned empty recordset, i tried using using '#' and 'datevalue' function but the result is same please help me
>the query written by me is
>select * from person_registration_details where expiry_date=datevalue(date)
>thanks in advance