isnll problem in access

hi guys

iam using isnull(var,'ABC') is my query but then is an error that isnull is undefined plz what is replacement of isnull is access

Thanks

Please post the SQL in question

S-

here is my sample sql query which is fine with sqlserver but in access its not working at all, here i took M and 1255 as contact but basicaaly it will be a vaiable and if that variable doesn't have any data it will be replaced by the all values of that particular field.



Select suppliername,address from suppliers where suppliername like isnull('%M%',suppliername) and address like isnull('%1255%',address)

if u have any problem,plz let me know

Use an If Statement

IIf(Expression,true,false)

ISNull is not a valid function in Access in access ( aleast the way you want to use it)


S-

thanks for ur reply can u write a little query with iif (expression) and didn't get

SELECT tblCustomer.CustKey, tblCustomer.CustST, IIf([CustST] Is Null,"No State Listed",[CustST]) AS State
FROM tblCustomer;

Thanks to supersubra I learned that there is an equvilant function to isnull

nz([CustST],"No State Listed")

S-