what is equivalent in SQL server of nz function in ACCESS

  • Thread starter Yogesh Upadhyay
  • Start date
Y

Yogesh Upadhyay

Hi there,
I am trying to run Access based database into SQL server
2000. Now all backend tables in SQL server and query,
forms, modules in local (client) PC. sql SERVER gives
error as "zn is not a recognized function name" Can you
please tell me if there is any function which can run for
both Access and SQL. What is SQL server's equivalent
function to nz..

Thanks in advance..

Awaiting...

Yogesh Upadhyay
 
V

Vadim Rapp

YU> I am trying to run Access based database into SQL
YU> server 2000. Now all backend tables in SQL server
YU> and query, forms, modules in local (client) PC.
YU> sql SERVER gives error as "zn is not a recognized
YU> function name" Can you please tell me if there is
YU> any function which can run for both Access and
YU> SQL. What is SQL server's equivalent function to
YU> nz..

ISNULL

Vadim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Function required - Choose() 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL function equivalent 3
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
FIRST method in SQL Server not recognized 4
DSN for SQL Server 2008 from Access 4
Upsizing wizard access Sql Server express 7
Access to SQL Server 9

Top