Just because I can't help myself, you may find the whole thing more readable, and easier to maintain with a CFSWITCH statement in place of all those ELSE's. Also probably more performant with only parsing the string once or twice per loop.
<cfoutput query="Recordset1"> <cfset route = "Invalid"> <cfswitch expression="#mid(current_route_id, 1, 2)#"> <cfcase value="01"> <cfset route = "Phoenix"> </cfcase> <cfcase value="02"> <cfset route = "P"> </cfcase> <cfcase value="03"> <cfset route = "M"> </cfcase> <cfcase value="04"> <cfset route = "S"> </cfcase> <cfcase value="05"> <cfset route = "T"> </cfcase> <cfcase value="07"> <cfset route = "X"> </cfcase> <cfcase value="08"> <cfset route = "PU"> </cfcase> <cfcase value="09"> <cfset route = "UPS"> </cfcase> <cfcase value="10"> <cfset route = "G"> </cfcase> <cfcase value="11"> <cfset route = "Inactive"> </cfcase> <cfcase value="A0"> <cfif listFindNoCase("A01,A02,A03,A04", mid(current_route_id, 1, 3))> <cfset route = mid(current_route_id, 1, 3) /> </cfif> </cfcase> </cfswitch> <!-- Outputs the variables in Recordset in a table --> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4