Thanks for that.  I was trying everything.  Appreciate your time.

Sorry we are not using SSMS.  we use a third party report generator called Dev express and they don't have any format options so I just need to get the...

Thank you Steve. This works perfectly.