Also, since Sybase ASE uses a lot of the same T-SQL constructs, you can attempt some methods located here: http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12
-- Matt "Noam Giladi" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > a solution offered i received from "raydan > > Untested: > Untested: > declare @num int > set @num = 20 > > EXEC ('select top 10 from myTable > where ID not in (select top ' + @num + ' from myTable order by ID) > order by ID') > > But beware the dangers of dynamic SQL. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php