> Oh you misunderstood. I know this and that is how I did it.
>
> When I was playing around with the select I just noted the returned
> name of the result
> field as substr and thought it an odd choice.

If you use COUNT or MAX then you get that as the default
name - I think that is the correct responce if it's not
changed by an AS XXX.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services