i thing that u have some names with spaces at the beginning
use this select to find
select substring(upper(fname), count(*) from customer group by 1
Att,
Alexis Diel
On Sat, Aug 3, 2013 at 5:01 AM, Masotti Umberto wrote:
> **
>
>
> Field fname is NOT NULL?
> count(*) value differs from count
Field fname is NOT NULL?
count(*) value differs from count(fname) AFAIR.
Inviato da iPad
Il giorno 01/ago/2013, alle ore 16:20, "ASOrg" ha scritto:
>
> Dear All
>
> select count(*) from customer ( returns 235384 )
>
> select count(*) from customer where substring(upper(fname) from 1 for 1 )
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
On 01/08/2013 15:20, A
Dear All
select count(*) from customer ( returns 235384 )
select count(*) from customer where substring(upper(fname) from 1 for 1 ) in
('A','B','C',
'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
( returns 187671 )
so there are 47.713 records who