<!--- Build an Alpha query. ---> <cfset qAlpha = QueryNew( "" ) /> <!--- Populate that query with a single column of letters. ---> <cfset QueryAddColumn( qAlpha, "letter", "CF_SQL_VARCHAR", ListToArray( "1,2,3,4,5" ) ) /> <!--- Build a numeric query. ---> <cfset qNumeric = QueryNew( "" ) /> <!--- Populate that query with a single column of numbers. ---> <cfset QueryAddColumn( qNumeric, "number", "CF_SQL_VARCHAR", ListToArray( "A,B,C,D,E" ) ) />