Set a rowcount limit

Is there anyway to use a command similar to SET ROWCOUNT 10 in an sql statment. example: set rowcount 10 select * from bigtable set rowcount 0 this would show just the first 10 records of a big table. Thanks for any ideas. -- Adam Richards MCI WorldCom - V622-1328 WWW: http://166.37.1.157/ EMAIL: adam.richards@mci.com

Depending on which verszion of the engine you are running. 7.3 came with a nice little addition to the SQL language that allowed you to return x number of rows from within a select statement. I don't think this exists in the earlier versions. It goes something like SELECT FIRST 10 col1, col2, col3 FROM table; Sean Adam Richards wrote in message <36C31391.BA1025B9@mci.com>... >Is there anyway to use a command similar >to SET ROWCOUNT 10 >in an sql statment. > >example: > >set rowcount 10 >select * from bigtable >set rowcount 0> >this would show just the first 10 records of a >big table. > >Thanks for any ideas. > >-- >Adam Richards MCI WorldCom - V622-1328 >WWW: http://166.37.1.157/ >EMAIL: adam.richards@mci.com > >