Hi All

Is their any way to return the first 5 records in a dataset including a
count of the total number of rows.

What I want to do is eliminate the number of data over the network but still
inform the client that for example only the first 5 of 55 rows returned.

Hope this is clear enough.

I know that

select first 5
From table_x
Where Field_x = 'XXX'

Would return the first 5

Regards
Louis Werth