SIMPLE SQL QUESTION.

Is
CV>there a way, without creating some sort of dummy field, to write a SQL CV>query so that instead of returning all records satisfying a where clause,
CV>it returns only the first 5 records satisfying that clause.

CV>Is there an easy way to do this?

In pure SQL, I don't think so. With Oracle extensions, you can open a cursor and just process the first five rows with a loop.

hth -

jh

---
. MR/2 1.39x NR . OS/2'ing it big-time!!