SELECT ind, count(*) as cnt FROM ( SELECT CASE WHEN ASCII(LEFT(COMPANY_NAME_IN_PRGM,1)) BETWEEN 49 AND 57 THEN '0-9' ELSE UPPER(LEFT(COMPANY_NAME_IN_PRGM,1)) END as ind, ID FROM vboothAssignment WHERE EVENT_CODE = 'EXPO2010' ) as A GROUP BY ind ORDER BY ind SELECT * FROM Exhibitor_Index WHERE ind = '0-9' 0-90-9   SELECT * FROM Exhibitor_Index WHERE ind = '#Chr( i_Letter )#' #s_Letter# #s_Letter#
  

SELECT COMPANY_NAME_IN_PRGM as Company, BOOTH_NUMBER, website FROM vBoothAssignment WHERE EVENT_CODE = 'EXPO2010' ORDER BY COMPANY_NAME_IN_PRGM

	Exhibitor	Booth Number
	#Exhibitors.Company#	#Exhibitors.Booth_Number#