> Hi,
> You've mentioned First as used for sampling data at least twice now. This
> is not an sql standard and I've never heard of it before. Who uses it

like

> this?

In all honesty I cannot remember, but it isn't something I have made up. I
can distinctly remember reading about an SQL DB providing both TOP and
FIRST. They also make sense in an English speaking way too, TOP would be
more appropriate than FIRST.

Pete
===
http://www.HowToDoThings.com