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