>>Hi! I'm having trouble in querying my tables. I have the ff. syntax:
>>
>>Select * from mytable where mydatecolumn='08/10/1999'
>>
>>It returns no rows though the table is not empty. How do I fix this so that I get all the records regardless of what time during the day they were saved. Thanks for all the help!
>>
>>Carlos
>
>It's been a while, but try
>
>SELECT * from mytable where CONVERT( C(10),mydatecolumn,101)='08/10/1999'
>
>this gives date in mm/dd/yyyy format

I think that its char(10) rather than c(10) (in SQL 6.5 anyway)

You can also try

SELECT * from mytable where mydatecolumn like 'Aug 10 1999%'