>thanks. i was hoping i can do it without having to do a sql select. iguess i don't have a choice. :)
Hmm... It depends on what you're trying to do, but how about a relation, with the Bank table as the parent (ordered by Bank Name), and the transaction table as the child.
You could then use SET SKIP to be able to scan through and hit all the child records.
Peter Franz