Be careful that you don't affect performance. Something like this:
WHERE
CONVERT(varchar(10), datecolumn, 112) = '20010531'
may affect performance bacause SQL Server cannot use an index to solve the query. You might want to try something like:
WHERE
datecolumn >= '20010531' AND datecolumn < '20010601'
Just my two cents.
-Mike