There are two ways. In MS SQL server 7.0 you can do SELECT TOP <#>
If you are on 6.5, then you need to do set the row count
environ variable, e.g something like "set rowcount <#>"
-Original Message-
From: disko_kex
To: [EMAIL PROTECTED]
Sent: 2003-07-02 19:20
Subject: [PHP-WIN] MSSQL
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
