Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    20

    Question Unanswered: searching a string by case

    Hi

    I have a problem I hope someone out there can help me with

    I have a string (str1) that contains both upper and lower case letters similar to this :
    AxnB

    and I want to search the string based on the upper case characters only, I have a table containing all the characters Im looking for(in upper case) and I am comparing using InStr, but it is ignoring case

    is there a way to either search by case, or remove lower case letters from the string?

    I am running Access 2000

    Thanks

  2. #2
    Join Date
    Aug 2005
    Posts
    20
    Never mind

    Figured this one out

Posting Permissions

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