slim wrote:

> Can any one tell me what the sintax is for select last 100. I know that
> Slect First 100 * from works ok but can not find and details for select Last

AFAIK, you have two solutions for this:

1. select count(*) and calculate which are the last 100 records
2. change the order by (asc to desc) and keep FIRST 100 in query

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net