Hi Roy, If your statement "X" is represented below by "select ... Order by ..." Then would the following give you what you're looking for??
create temp table Xtab as (select .... Order by ....); select ROWID from xTab where MemberID=4567373; (Without some "order by" clause, by the way, the rowid won't make sense -- don't rely on any default ordering) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
