i want to append the expiry date to a variable like below..

DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003'

SET @Prod=@Product_name + RTRIM(@Product_name)

+SELECT '(Expires '+RTRIM(DATENAME(MM, @Expiry_Date ) + RIGHT(CONVERT(VARCHAR(12), @Expiry_Date ,107),9))+ ')'

but its not working...