Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    16

    Unanswered: Case-Sensitive Query?

    Is it possible to create a case specific search using the like operator with an input from a form text box?

    For example: If I type "Al" in the textbox, I would want the results to include Almond, but not "almond". Likewise, if I type "al" in the textbox, I would want the results to include "almond", but not "Almond"

    Thanks in advance!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    consider using the option compare binary
    can be set in code, and or the settings / properties for the db.
    Im not sure if you can use this selectively in a form (ie toggle the mode during the forms execution or whether you set it one per form
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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