Does MSSQL support LIMIT

Hi,

I'm creating a software, and I have a dilemn... To check it I use MySQL, but I want my software to use a lot of kind of diffrent DB (oracle, DB2, informix, etc...)

But I have to know :

Does MSSQL support something like that (and if not how to do it) :

SELECT fields FROM Table LIMIT 0,500

??

thank you very much for a quick answer, because All development depend of the answer !!!

thank you,
bye.no, it doesn't

you'll have to use TOP instead, which is explained in the manual