Simple quick question.

I`m using a simple group by and instead of getting the results I expect, MS Sql seems tso have merged the data, case insensitively.

eg.
RUA or Rua or rua all get put together as RUA (or whichever record it finds first).

I don`t remember having this problem in Access. If the data was different I got different lines.

Is it an easy fix? A setting on the MS Sql? an extra option in the SQL statement ?