Find Questions Using Question Text

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%';

Marine