I have a table with the following fields:
CR NO
DT
FNAME
LNAME
ADD
AMOUNT
In this CR NO is Pimary key.
I want to find those people whose amount totals 50000 and above.
The prob is that the names are typed haphazardly, For example Jack Jill Thompson...