<cfquery name="test" datasource="#request.DSN#"> SELECT TOP 1 (productID), ProductDesc FROM tblproduct </cfquery> Above is sql - this is quicker I believe I think it is because the sql only searches the top 1 row while CF searches the whole database then returns 1 row (I think) Seamus