I am trying to convert a date field in sql to a DD:MM format
example
right now its 01-16-2007 and i want to convert it to 01-16 and forget the year at the end

any help?

again this is for SQL Query im working on in SSMS 2005

You can look in BOL at the CONVERT function and see if any of the styles does what you want. I suspect not, so you'll probably end up using the DATEPART function to concatenate the month and day together.