Declare fldname string;
Declare curs cursor as Select * from MWPAT;
Declare tmpstr integer;
Create Table #tmpTable(ChartNumber char(10));

open curs;
while fetch curs do
try
if curs.[Date Modified] is not null
then tmpstr = DayOfYear(curs.[Date Modified]);
end if;

catch all
insert into #tmptable (ChartNumber) values  (curs.[chart number]);
end try;
end while; 

Select * from #tmpTable