Case Sensitive

Results 1 to 2 of 2

Thread: Case Sensitive

  1. #1
    Join Date
    Dec 1969

    Default Case Sensitive

    My Sql is working -- if i search using the UPPERCASE data like "RP", or "NS" (data is like this in the Table) but it should work if user enters like "Rp" (Capitol "R" and Small "p") or it has to work if both are in lower case "rp"... <BR><BR>If i enter "rp"(lower case) its not working - Please help me to do the search using Upper/Lower case...<BR><BR><BR>-----------------------------------------------------------<BR><BR>gstrSQL = "SELECT ENROLL_REP, GENDER From LIFERACEP WHERE ENROLL_REP LIKE &#039;" & ENROLL_REP & "%&#039; "<BR>----------------------------------------------------------

  2. #2
    Join Date
    Dec 1969

    Default RE: Case Sensitive

    I don&#039;t know why your db is set up for sensitivity, but instead of getting a headache about it, just ucase it.<BR><BR>LIKE &#039;" & UCase(ENROLL_REP) & "%&#039;"

Posting Permissions

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