SELECT 
p.codenum   ,  
Trim(upper(replace(p.proccode,' ','0'))) proccode ,  
if(f.Amount is null,0,f.Amount) AMOUNT  ,   
p.datetstamp , 
left(p.Descript , 255) Descript  
FROM procedurecode p  left join fee f on p.codenum = f.codenum
where p.codenum = <@CODENUM@>
 
order by p.codenum