On Mar 23, 2006, at 19:22, David Johnson wrote:

> I take that back ... vanilla SQL doesn't handle that well.
> Firebird SQL
> supports the FIRST predicate, so I'm barking up a tree.

Every SQL engine I have run into has some syntax for this:

<http://sqlzoo.net/pt/howto/source/s.pl.htm?file=tip915069>

So while it may not be "vanilla", it is pretty universally supported.
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com