https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaa-p/13814554#M4845397 <P>This helps you?</P> <LI-CODE lang="sql">SELECT COMPARE( 'abc','ABC','UCA(case=LowerFirst)' ), COMPARE( 'abc','ABC','UCA(case=Ignore)' ), COMPARE( 'abc','ABC','UCA(case=UpperFirst)' ); </LI-CODE> <P>I got it in Documentation...</P> Fri, 20 Nov 2009 23:32:39 GMT Former Member 2009-11-20T23:32:39Z https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaq-p/13814553 <P>Any way to compare two strings using case sensitivity even though the database is case insensitive?</P> <P>SQLAnywhere 10.0.1.3835</P> Fri, 20 Nov 2009 23:15:01 GMT https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaq-p/13814553 Former Member 2009-11-20T23:15:01Z https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaa-p/13814554#M4845397 <P>This helps you?</P> <LI-CODE lang="sql">SELECT COMPARE( 'abc','ABC','UCA(case=LowerFirst)' ), COMPARE( 'abc','ABC','UCA(case=Ignore)' ), COMPARE( 'abc','ABC','UCA(case=UpperFirst)' ); </LI-CODE> <P>I got it in Documentation...</P> Fri, 20 Nov 2009 23:32:39 GMT https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaa-p/13814554#M4845397 Former Member 2009-11-20T23:32:39Z https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaa-p/13814555#M4845398 <P>That did the trick, thanks a lot!</P> Sat, 21 Nov 2009 01:20:50 GMT https://community.sap.com/t5/technology-q-a/case-sensitive-string-comparison-in-a-case-insensitive-database/qaa-p/13814555#M4845398 Former Member 2009-11-21T01:20:50Z