Viewing post 1 (of 1 total)
Or try this on:
select convert(varchar,birthDate ,101)
From delete_temptest
order by datepart(month, dateadd(m,-6,birthDate)),
datepart(day,birthdate)
December 22, 2005 at 10:12 am
#611181