I guess I should read more closely.. I think with your MySQL, you will want to use the LIMIT instead of TOP.

Please see: http://dev.mysql.com/doc/mysql/en/select.html

HTH,

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's