Обсуждение: SQL question

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 <tyr@teiresias.net>