I am trying to build an application, which will work on MS Access and SQL Server. I have some queries written by someone using the Visual Basic "FORMAT" function. I didn't find anything that will be compatible with "Format" in SQL Server. "Cast/Convert" can't solve this issue.

Sample Statements:

 Select Format(Amt, "###,##.##") as Amount from Table A Select "Balance: " & Format(Amt, "###,##.##") as Amount from Table A

Any advice other than to change the current statements?