Case Sensitive

Results 1 to 2 of 2

Thread: Case Sensitive

  1. #1
    Join Date
    Dec 1969

    Default Case Sensitive

    I am doing a search and getting the results. <BR>If the the Data in the Table is "Black" and if a Search using "BLACK" (All Upper Case), i am NOT getting the results. And i tried UCASE too...<BR><BR>Here is my SQL:<BR>---------------------------------------------------------------<BR><BR>gstrSQL = "SELECT DESC, CNT From LIFE WHERE DESC LIKE &#039;" & DESC & "%&#039; "<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Case Sensitive

    gstrSQL = "SELECT DESC, CNT From LIFE WHERE UPPER(DESC) LIKE &#039;" & UCase(DESC) & "%&#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