I have a table with a date field: dDate and thousands of records.

The dates are scattered over time including the future. I need to find =

the record with the max date that is =3D< required date.

How would you do this with sql select and also with Locate?

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---