Home Forums SQL Server 2005 T-SQL (SS2K5) find whether a upper case letter is there in a given string RE: find whether a upper case letter is there in a given string

  • Just a quick clarification:

    SQL may consider 'SARAT' , 'Sarat' or 'sarat' as equals; depending on the Collation;

    which means that you should use "...BINARY_CHECKSUM(LOWER('SARAT')..." ;

    if simply using "...LOWER('SARAT')...", then you should add "...COLLATE Latin1_General_CS_AI...".

    "_CS_" stands for Case-Sensitive...; by defaut the Collation is "_CI_" which means Case In-sensitive;

    Gr8 answers from all of you!

    Cisco.