format in sql server

How to Display currency symbol in SQL Sever?

Sometimes we are required to display a currency symbol along with the amount in query result set, It becomes challenge to displaying a currency symbol with amount.