You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?
A.
FIND
B.
BETWEEN
C.
INCLUDES
D.
LIKE
Which keyword should you use in your where clause?
You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?
BETWEEN and FIND don’t make sense.
LIKE is the correct answer.
Keyword in the statement is ‘contains a specific character’ you can only use ‘like’ for a specific character.
Between operator selects values within a given range. Where Price is Between 10 AND 20.