Find Questions Using Question Text

Owned by Roxanne Lafleur (Unlicensed)
Jul 05, 2019
  • Work Process - Purpose

    • Finding a question for the Client Group using the question's text.

  • Work Process - Summary
    • A simple DB query.
  • Contribution Of The Client Group To The Work Process

    • The Client Group to provide question text to be queried.

  • Steps Of The Work Process
    • For English questions:

      SELECT *

      FROM TM103_QUESTION

      WHERE UPPER(QUESTION_ETXT) LIKE '%WHAT IS THE NUMBER ONE%';

      For French questions:

      SELECT *

      FROM TM103_QUESTION

      WHERE UPPER(QUESTION_FTXT) LIKE '%VOUS DEVEZ VOUS ASSURER%';