Getting records for same value

I have two records, "Sawah Sempadan" and "sawah sempadan"

How to get only "Sawah Sempadan" from Query ?It show me two records contains "sawah sempadan" and "Sawah Sempadan"

Code:

---

.Open "SELECT DISTINCT Kompartment FROM Kompartmen"

---

Hi,

One thing about distinct, it does return the first record spotted in your table and does not matter about case sensitivity...i guess the small caps sawah sempadan was the first occurence in your table..If you re-arrange the record so that the capital Sawah Sempadan will be the first occurence, it will display with the desired result your after..

Greg

But let me guess, are they the same compartment?

Greg

What is the backend database?

Case Sensitivity is a setting that can be changed on MS SQL Server. Although I believe it's a "server-wide" setting.

But as was already questioned - are they the same compartment? If they are then that would have us question the table design you have selected, as proper normalization would never allow this to occur.