I believe you would achieve the same results by saying select top 10 * from system_users where lastnamelike "C%"
Eddie -----Original Message----- From: Cesar Cordovez [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: [PHP] Nothing to do with PHP But, I'm sure someone in this list have the answer to my question: I have written a lot of statements using the LIMIT clause in MySQL, like for example: SELECT * FROM system_users WHERE lastname like "C%" LIMIT 0,10 ...and I love it. specially when you are doing "next page", "previous page" kind of stuff. One of my clients wants to install my system in (*&^%$# MSSQL server. How can I do a LIMIT in MSSQL (or other?) Any comments welcome. TIA. Cesar -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
