I'm using a DSO to extract a record from SQL-server. The SQL-string looks

like so:



SELECT * FROM bx WHERE (base_vortriebsfront='Euerwang Portal Sued') AND

(base_datum='17.06.1999')



Only problem, if the time portion of DATETIME is not 6:00AM but say 7:30AM

no rec's are returned. How can I search for the date portion only, i.e.

ignoring the time portion?



Dirk