Well, a couple of sample dates would have done rather than dozens, but your answer is: Using @a to represent your column declare @a nvarchar(50) set @a = '28/10/2008' set dateformat dmy select convert(varchar,datepart(day,@a)) + '/' + left(datename(month,@a),3) + '/' + convert(varchar,datepart(year,@a)) You need the set dateformat dmy so SQL knows its day month year
Bob Ashfield Consultants Ltd