DOH!!!! (Bashing head on wall)
Thanks for the heads up!
>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'
Sylvain Demers