First QuerySET @Prod=@Product_name + RTRIM(@Product_name) + ' (Expires '

+RTRIM(DATENAME(MM, @expriry_date ) + RIGHT(CONVERT(VARCHAR(12), @expriry_date ,107),9))+ ')' +CHAR(10)

Result is : Product : Vehicles (Expires September 30 2012)

Second QuerySELECT '(Expires '+RTRIM(DATENAME(MM, GETDATE()) +','+ RIGHT(CONVERT(VARCHAR(12), GETDATE() ,107),9))+ ')'

Result is : Product : Vehicles (Expires September, 30 2012)

--

I want comma after September 30.

Eg: September 30, 2012