create function dbo.abc( @job_id decimal ( 20 ), @job_lvl decimal ( 20 )) returns decimal as begin return ( @job_id * @job_lvl ) end select pub_id,job_lvl,dbo.abc (pub_id,job_lvl) YOYO from employee