Undefined function 'nz' in function

[sundarv]

hi
i have a query in my access2k which converts null values to zero in the calculated field. This works fine in my access2k. when i want to retreive the values from this query thru ASP page, i m getting an error
"undefined function nz in the expression. Microsoft jet database engine error". im using microsoft .jet.oledb4.0 in my asp program.

Is there any other function other than "NZ"function to convert null values to zero in the backend .

please help
sundar

[scullee]

if you are using SQL server you can use ISNULL and under oracle you can use NVL