--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:

>
> What happens if you try:
>
> Select
> ca.id,cn.firstname,cn.lastname,cn.email1,cn.dateofbirth, ca.kind,ca.category,ca.status,cn.name
> from person cn
> JOIN extendedperson ca on ca.personid=cn.id
> where (upper(cn.name) starting with 'S')

Didn't make any real difference.

> Do you have an index on cn.name?

Yes Sean.

The name field is varchar(200) - perhaps this is part of the reason?
Tom