I am in the process of migrating from Access local tables to using a SQL Server back-end database. I was trying to convert SQL strings within my Access application into stored procedures.
How would I convert the following SQL string from my Access application into a stored procedure ?
CREATE PROCEDURE dbo.procTest AS ...
Format(Nz([CashBalance],Nz([Quantity],0)),'#.000') AS [Check/Cert Amount]
I get the error message:
Error 195: 'Nz' is not a recognized function name.
If I remove Nz, I get the error message:
Error 195: 'Format' is not a recognized function name.