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