On Wed, 31 Oct 2001 14:52:58 -0500, Brian Stoughton <[log in to unmask]> wrote:

>My question is - is there a better way of doing this?

You don't actually need the SQL database to do this, although it won't hurt, it
will just change the job structure.

Read the section in the Developer's Guide

  http://www.lsoft.com/Manuals/1.8d/Developer/developer.html#4.6.4

on  'Using &*INDEX to select random samples'

This can be done as a List-Based Mail-Merge DISTRIBUTE job (LSMTP will be
required) entirely within LISTSERV and LSMTP without need for a SQL database.