Question

    Which is used to find similar character/string in

    SQL?
    A Alter Correct Answer Incorrect Answer
    B % like Correct Answer Incorrect Answer
    C Underscore Correct Answer Incorrect Answer
    D Both 2 and 3 Correct Answer Incorrect Answer

    Solution

    The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator. The percent sign (%) The underscore (_) The percent sign represents zero, one or multiple characters. The underscore represents a single number or character. These symbols can be used in combinations.

    Practice Next

    Relevant for Exams: