display currency symbol in sql

The  SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.