Hi Alan
Thank you for your reply

It returns 38212.
It is resolved now with the help from Nick ( I posted with different and wrong subject )

Thank you very much and best regards
Andy

--- In firebird-support@yahoogroups.com, Alan J Davies <Alan.Davies@...> wrote:
>
> Try this
> select count(*) from customer
> where substr(fname,1,1) not between upper('A') and upper('Z')
> gives you the count
>
> select fname from customer
> where substr(fname,1,1) not between upper('A') and upper('Z')
> order by fname
> gives you the records
>
> Alan
>
> Alan J Davies
> Aldis
>