I am trying to covert a numeric field into Currency in French Format .
I tried using FormatCurrency(<Amount>,<Currency>), but it throws an error:
ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot find either column "MA_UAT" or the user-defined function or aggregate "MA_UAT.FormatCurrency", or the name is ambiguous. SQLState: 37000
Is there a way to achieve this through a function or a code?