On Mon, 10 Nov 2003 at 12:33, Reinhard Max wrote: > SELECT DISTINCT *,length(code) > FROM a > WHERE '00442085673456' LIKE (code || '%') > ORDER length(code) DESC; ^ BY Oops, that one got lost when I re-formatted the query. cu Reinhard