Select * from yourtable where upper(alltrim(yourfield))='A'Note that VFP9SP2 will also select all the records where yourfield is empty!!! This must be a bug?
Select * from yourtable where upper(alltrim(yourfield))='A'
Use yourtable Browse for upper(alltrim(yourfield))='A'In all cases I have Set exact OFF and Set ansi OFF.