It's not as easy with MSSQL, but the TOP syntax should work. SELECT TOP 10 user,email FROM userdb WHERE user LIKE '%b%'
Regards, Nick H. Network Operations Center [EMAIL PROTECTED] ----- Original Message ----- From: "disko_kex" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 12:20 PM Subject: [PHP-WIN] MSSQL HELP : In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So : how do I make it page in MSSQL? : : -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php