I'd like to query a sql 2000 DB and return a recordset that will be sorted alphabetically into a two column table like the one below. I'd like to do it using CF 5 code. I can write the query and sort the results, but don't know how to get the results to display in two table columns sorted alphabetically. The two columns need to be balanced so that the columns are the same length, or as close as possible, and there is no way to know how many items there will be in the list before the query runs so the row number can't be hard-coded in the query.
COLUMN 1 COLUMN 2
American Elk Nubian Goat
Asian Elephant Pygmy Goat
Brazilian Tapir Sicilian Donkey
Common Zebra Sika Deer
Domestic Sheep Vietnamese Pot Belly Pig