When a query involves a character field,such as CustomerName,you must enclose the value to which the field is being compared in percent symbols (%).

Name: When a query involves a character field,such as CustomerName,you must enclose the value to which the field is being compared in percent symbols (%).
Brand: Quizplus
Rating: 4.8 (32 reviews)

Question

Quizplus · Accepted Answer

Percent symbols (%) are used as wildcards in SQL for pattern matching, not for enclosing values. Values are typically enclosed in single quotes (' ') for character fields.

When a Query Involves a Character Field,such as CustomerName,you Must