SAP
C_TAW12_740 · Question #41
You want to select all record from a database table where field City contains substring 'BIT in any position. Which WHERE clause can you use in an Open SQL statement?
The correct answer is D. WHERE city LIKE '%BU%'. See the full explanation below for the reasoning.
Question
You want to select all record from a database table where field City contains substring 'BIT in any position. Which WHERE clause can you use in an Open SQL statement?
Options
- AWHERE city LIKE 'BU'
- BWHERE city LIKE '+BU+'
- CWHERE city LIKE 'BU'
- DWHERE city LIKE '%BU%'
How the community answered
(18 responses)- A11% (2)
- B6% (1)
- C6% (1)
- D78% (14)
Community Discussion
No community discussion yet for this question.