Case Sensitive search

Results 1 to 3 of 3

Thread: Case Sensitive search

  1. #1
    Raf Guest

    Default Case Sensitive search

    how can i make query which is case sensitive in access and sql server7 (to make password matching case sensitive using asp)<BR>generally all matches are not case sensitve . pl give soln.

  2. #2
    Join Date
    Dec 1969

    Default RE: Case Sensitive search

    do the comparison with a regular expression.<BR><BR>j

  3. #3
    Eddie Campbell Guest

    Default Or use StrComp

    If you use StrComp with a binary comparison to compare two strings, it will do a case sensitive check.<BR><BR>E.g.<BR><BR>MyStr1 = "ABCD": MyStr2 = "abcd"<BR>MyComp = StrComp(MyStr1, MyStr2, 1)<BR><BR>MyComp = 0 because the strings do NOT match. For more info view the Vbscript Resource at

Posting Permissions

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