Case Sensitivity 2

[GGleason]

When I group a field, two records show up as identical. For example:

ABC_MM
ABC_mm


Is there a switch that takes into account case sensitivity?

TIA,
GGleason

 

[tlbroadbent]

I don't know of a switch or option. You can write a function and use the function in an Group By clause.

Function:
Public Function StringToAsciiValue(strIn As String) As String
Dim i As Integer, strOut As String

For i = 1 To Len(strIn)
strOut = strOut & Asc(Mid(strIn, i, 1))
Next i

StringToAsciiValue = strOut
End Function

-------------------------------------

Query example:
SELECT FieldName
FROM Emps
GROUP BY
FieldName,
StringToAsciiValue([FieldName]); Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[GGleason]

Terry,

What a clever solution! It's working fine.

Thanks,
GGleason