> I'm getting an error - is "TOP" supported in MySQL? I'm not sure, but can't you use LIMIT instead? e.g. SELECT * FROM table WHERE this='that' ORDER BY this LIMIT 1 would return 1st record. Simon