QUESTION POSED ON: 21 January 2004
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?
|
