Access Equivalent for SQLBASE Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What would be an equivalent Access query for this SQLBase query?

select @nullvalue(@nullvalue(d.warehouse_id, ln.warehouse_id),
co.warehouse_id ), 0, from location;

Thank you.
 
How about you write in English what the query should do, and we'll translate
to SQL?
 
Hi shar,


SqlBase: select @nullvalue(status, 'expired') from table

MSSQL: select isnull(status,'expired') from table

Access: select iif(isnull(status)=false,status,'expired') from table

bye
 
giorgio rancati said:
Hi shar,


SqlBase: select @nullvalue(status, 'expired') from table

MSSQL: select isnull(status,'expired') from table

Access: select iif(isnull(status)=false,status,'expired') from table
Click to expand...

your query
select iif(isnull(d.warehouse_id)=False, d.warehouse_id,
iif(isnull(ln.warehouse_id)=false, ln.warehouse_id, co.warehouse_id )), 0
from ...;

bye
 
Back
Top