Case-Sensitive String Comparison (In a Case-Insensitive Database)

[Former Member]

Any way to compare two strings using case sensitivity even though the database is case insensitive?

SQLAnywhere 10.0.1.3835

[Former Member · Accepted solution]

This helps you?

SELECT COMPARE( 'abc','ABC','UCA(case=LowerFirst)' ),
       COMPARE( 'abc','ABC','UCA(case=Ignore)' ),
       COMPARE( 'abc','ABC','UCA(case=UpperFirst)' );

I got it in Documentation...

[Former Member · Accepted solution]

That did the trick, thanks a lot!