The best I can up with for now is:
Select Distinct UPPER(field1) From junk
which will give you the same result set but they will all be in UC.
Any help?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.