Select As VarChar But Order By DateTime

Hello,

I'm trying to CONVERT some DateTime column to VarChar in the SELECT part but still do a DateTime ORDER BY while using a UNION.

In other words, does anyone know how to make this work:


create table #temp1 (
d datetime
)

create table #temp2 (
d datetime
)

insert into #temp1(d)
select '2001-12-12' union
select '2002-11-11'

insert into #temp2(d)
select '2003-10-10' union
select '2004-09-09'


--works fine-------------------------------
select convert(varchar, d, 101) dd from #temp1
order by d
-------------------------------------------



--but can't make this work-------------------

select convert(varchar, d, 101) dd from #temp1
union select convert(varchar, d, 101) dd from #temp2

order by dd -- wrong type of sorting

--order by d-- error

--order by cast(dd as datetime) -- error

-------------------------------------------

drop table #temp1
drop table #temp2


I would really appreciate your help.

Thanks in advance,
Thomas