Oracle
nvl(expr,'某某')
含義:若expr的值為null,則用'某某'代替
舉例:
select nvl(pid_id,'0') from test_pid;
Access
nz(expr,'某某')
含義:若expr的值為null,則用'某某'代替
舉例:
select nz(max(pid_id),'0') from test_pid;
IIf(expr,express1,express2)
含義:若expr結果為TRUE,則取express1的值,反之取express2的值
舉例:
select IIf(max(pid_id) is null,'0',max(pid_id)) from test_pid