• Just a note of caution when using the date format styles - 103 will give you dd/mm/yyyy whereas 101 will give you mm/dd/yyyy...

    select convert(varchar,convert(datetime,'20050910'),103) as UKDate

    select convert(varchar,convert(datetime,'20050910'),101) as USDate







    **ASCII stupid question, get a stupid ANSI !!!**