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:16:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL - Need No Dups Based on Case
Miscellaneous
Thread ID:
00904952
Message ID:
00904952
Views:
57
I need one SQL statement that will return records with no duplicates based on case:
Raw data example:

Aa
Bb
CC
aa
Dd
bb
aA
ee

Desired result set:

Aa
Bb
CC
Dd
ee
Next
Reply
Map
View

Click here to load this message in the networking platform