Search a string not dependant on case

Janet_21505
Janet_21505 Altair Community Member
edited May 2020 in Community Q&A
​I want to search a string for a keyword.  Is there a function that does not care about the case of the keyword?

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
Tagged:

Best Answer

  • Janet_21505
    Janet_21505 Altair Community Member
    edited May 2020 Answer ✓
    INSTR function worked for me. 

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 05-21-2020 11:23 AM
    From: Janet Grimsley
    Subject: Search a string not dependant on case

    I want to search a string for a keyword.  Is there a function that does not care about the case of the keyword?

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

Answers

  • Janet_21505
    Janet_21505 Altair Community Member
    edited May 2020 Answer ✓
    INSTR function worked for me. 

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 05-21-2020 11:23 AM
    From: Janet Grimsley
    Subject: Search a string not dependant on case

    I want to search a string for a keyword.  Is there a function that does not care about the case of the keyword?

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

Categories