Multiple choice technology databases

Retrieving data end with "abc" which wildcard use with like keyword?

  1. abc%

  2. %abc_

  3. %abc

  4. %abc%
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To match strings ending with 'abc', use '%abc' where % matches any characters (including none) before abc, and abc is the literal ending. 'abc%' would match strings starting with abc, while '%abc_' requires at least one character after abc.

Keep practicing — related questions