SELECT * FROM awards02 ORDER BY statename select distinct state from awards02 order by state 2002 PTFP Awards By State


Select State

#curstate# #curstate#  


#statename#

#legal_name#
#org_unit#
#trim(city)#, #state#
#award_no#

#paragraphformat(descrip)#
Contact: #contact#
Phone (#Left(phone, 3)#) #Mid(phone, 4, 3)#-#Right(phone, 4)#
Federal Amount $#NumberFormat(tot_award,"999,999,999")#
Total Project Cost $#NumberFormat(tpc,"999,999,999")#





This page was last updated on 09/26/02.