问个SQL::Statement的问题

select isnull(a.no,b.no) as no,isnull(a.name,b,name) as name,a.city,b.job from tb1 as a full join tb2 as b on a.no=b.no

这个语句用SQL::Statement怎么写

SQL::Statement里好像没有isnull这个函数