SELECT * FROM awards03 WHERE RT IN ('R','RT') AND MID(award_no,4,2) IN ('01','03') ORDER BY statename, legal_name select distinct state from awards03 WHERE RT IN ('R','RT') AND MID(award_no,4,2) IN ('01','03') order by state SELECT * FROM awards03 WHERE RT IN ('T','RT') AND MID(award_no,4,2) IN ('02','03') ORDER BY statename, legal_name select distinct state from awards03 WHERE RT IN ('T','RT') AND MID(award_no,4,2) IN ('02','03') order by state SELECT * FROM awards03 WHERE DigConv <> 0 ORDER BY statename, legal_name select distinct state from awards03 WHERE DigConv <> 0 order by state SELECT * FROM awards03 WHERE pc LIKE 'IC%' OR pc LIKE 'IP%' ORDER BY statename, legal_name select distinct state from awards03 WHERE pc LIKE 'IC%' OR pc LIKE 'IP%' order by state #title#


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/15/03.