SQL Question

Does any one know how to do following in SQL (Informix in particular)? I need to get the first row a SELECT statement finds, not all the rows. e.g. SELECT * from my_table where row_value < 10 .... should return first row with row_value < 10, even the table has many qualifying rows. A cc: will be much appreciated. TIA. -- Tin Zaw x.13205 mailto: tzaw@qualcomm.com Network Engineer QUALCOMM Inc. www.qualcomm.com