Case sensitive issue

  • I am using a REPORT to count the number of TOTALMEMBERS for each REGION ex.:

    Region totalmembers

    West 1234

    WEST 236

    My problem is that the Region is NOT case-sensitive, 'WEST' and 'West' are same But my report counts them as different (Case sensitive).can someone please help me on this.I checked the column collation and its not case sensitive.please I need some help.

  • Dup post

    Post replies here: http://qa.sqlservercentral.com/Forums/Topic1138304-1292-1.aspx%5B/url%5D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply