How can we distinguish by case for text values?

[csk003]

I have a table with City as column name and when I group by city I cannot distinguish between Dallas and DALLAS. They both are counted under Dallas. Even when I try to update Dallas to DALLAS all rows try to get updated instead of the ones with the exact case.

Is there any way to identify them separately?

 

[mhartman1]

Hello

In your code module you would use the statement:
Option Compare Binary

This allows you to distinguish between capital and non capital letters.

Regards
Mark

 

[PHV]

Mark, the Option Compare instruction has no impact on JetSQL I guess.

 

[mhartman1]

Hmmm. I did not know that. Thanks, I will do some perusing.

Regards
Mark

 

[Eupher]

csk003,

You may find the StrComp() function useful.

Ken S.