In the query: select field, length(field) from table where length(field) < 10;
How many times is the length() function called for each row? Once or twice? Thanks, -- Steve Chadsey <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])