Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Need No Dups Based on Case
Message
From
18/05/2004 11:42:40
 
 
To
18/05/2004 11:16:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00904952
Message ID:
00904965
Views:
16
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform