The closes i can come to this problem is

SELECT LEFT(CONVERT(DATE,VALUE,111),7) FROM #TEMP WHERE ID=2

still it is not working. Any one who can help !!!!!!!!