Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006

    Unanswered: case in sensitivity

    Dear Experts,

    I've been working with a product development cmpany, and we are making our product to support all the main databases. we finished for sql server, oracle. presently we started with DB2. I dont know how to start with this. I even dont know how to find the version of this db2. I'm starting with a,b,c,d......

    friends, please help me how can i make my database case-in-sensitive? I've the following link, but with that I can not make my database collation case in sensitive. so please help me in this regard.
    We dont know whether the client inserts data in which case. but while we selecting, all these should be concidered. that.

    we need to reuse the output in other queries..............please guide me

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    SELECT *
    FROM mytable
    WHERE UCASE(field1) = UCASE('age');
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    May 2006
    This thread is duplicated. The same issue was presented few days later, by the same user and it is @

  4. #4
    Join Date
    Aug 2001
    Thread locked. Responses to please
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts