sql question

[savok]

using the following gives me a list of all the codes after 05/16/2000, now if i wanted it to give me a list of only the codes ON 05/16/2000 what would i do? I changed the > to = and it didnt work. Why? thanks

select class_code from class where date_start > to_date('05/16/2000', 'MM/DD/YYYY')

 

[rtshort]

Try using "LIKE" instead of "=". That should work.

 

[savok]

worked wonders! thanks a lot