> What is the equivalent query in FireBird for the following MS SQL query
> [ select top 1 * from users where name='name' ]
> Thanks for any reply.

Reading the Firebird 1 release notes would have given you the answer...

SELECT FIRST n [SKIP m] ...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com