Nz() function in MS ACCESS, WHAT WILL BE THE EQUVALENT IN ADP OR SQL 1

[indraT]

Hi there,

I have Nz() function in my access database which i converted to adp with sql back end. now my Nz() function is not working or displaying the message saying there is no function Nz() from my adp file which link to sql server. Could i please have information by which function i can replace this function so that i can have same functionality.

Thanks in advance.

Indra.

 

[BobJacksonNCI]

Indra,

Works best if you copy/paste your SQL code here...

There is no exact equivalent of NZ in SQL.

CAST(IsNull(yourfield,'Null') AS varchar(4)

replaces null fields with the literal 'Null'



HTH,
Bob

 

[cmmrfrds]

The isnull() function will replace a null value.
isnull(mynumber,0)
If mynumber is null then it will contain 0.

 

[BobJacksonNCI]

Thanks cmmrfrds!

I made it more complicated than necessary.

Bob

 

[indraT]

Its working fine with IsNull() function. Thanks you all for help.

Indra.