Are you wanting to do this for moving to a specific row in a Table field? Some more info on what you are trying to do would be helpful. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Monday, May 12, 2008 1:00 PM To: [email protected] Subject: Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really time consuming it takes minutes to find my particular data. Thats why I thought of implementing Binary search in Remedy. It will considerably reduce the time to some seconds. Can eny one give some starting idea for the same.. ?? Syntactically my requirement is : I will be returned with 800 rows. I need to go to the particular row where coumn5 value = "XYZ" More ever if anyone can suggest how to come to know the row number of row that contain "PQR" in its column8. ARS 7.0.0 No ITSM (Customized appl) Oracle 10g Unix -- Thanks and Regards, Ganga Prasad Pattnaik, ------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

