case sensative search

Results 1 to 2 of 2

Thread: case sensative search

  1. #1
    Join Date
    Dec 1969

    Default case sensative search

    could you help me i'm trying to search a database which is currently case sensative i would like it to find the relavent data either way

  2. #2
    Join Date
    Dec 1969

    Default RE: case sensative search

    if it is Access or even SQL server I do it this way<BR><BR>Dim Searchtxt<BR><BR>Searchtxt="Find this"<BR><BR>in my query I set the search text and the field that I am searching to lower case<BR><BR>Sql="Select * From Table Where Lcase(Field1) like &#039;%" & Lcase(Searchtxt) & "%&#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