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:31:56
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
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
Title:
Re: SQL - Need No Dups Based on Case
Miscellaneous
Thread ID:
00904952
Message ID:
00904960
Views:
25


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

SELECT DISTINCT LOWER(myField) ... FROM ..
* OR
SELECT DISTINCT UPPER(myField) ... FROM ..
* OR
SET COLLATE TO "GENERAL" 
SELECT DISTINCT myField ... FROM ..
Previous
Reply
Map
View

Click here to load this message in the networking platform