There are two solution. You can use the ROWCOUNT connection setting:

SET ROWCOUNT 4
SELECT * FROM table WHERE ...
SET ROWCOUNT 0

But the better solution would be to use the TOP clause of the SELECT command, if you have something to sort on.

SELECT TOP 4 * FROM table WHERE ...

-Mike