• SQL Server 2008 has a Date datatype which will solve your problem when you are able to upgrade.

    http://brittcluff.blogspot.com/