SELECT * FROM awards02 WHERE RT IN ('R','RT') AND MID(award_no,4,2) IN ('01','03') ORDER BY statename select distinct state from awards02 WHERE RT IN ('R','RT') AND MID(award_no,4,2) IN ('01','03') order by state SELECT * FROM awards02 WHERE RT IN ('T','RT') AND MID(award_no,4,2) IN ('02','03') ORDER BY statename select distinct state from awards02 WHERE RT IN ('T','RT') AND MID(award_no,4,2) IN ('02','03') order by state SELECT * FROM awards02 WHERE DigConv <> 0 ORDER BY statename select distinct state from awards02 WHERE DigConv <> 0 order by state SELECT * FROM awards02 WHERE pc LIKE 'IC%' OR pc LIKE 'IP%' ORDER BY statename select distinct state from awards02 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/26/02.