what is equivalent in SQL server of nz function in ACCESS

  • Thread starter Thread starter Yogesh Upadhyay
  • Start date 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
 
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
 
Back
Top