Create a list of all students with middle initials (specifically, with a first name AND then a middle initial) AND remove the middle initial from the first name. Take care: some first names are a single initial only. [HINT: use the INSTR function embedded within other functions). .
What will be an ideal response?
```
SELECT first_name Name,
SUBSTR(first_name,1,INSTR(first_name,' ') - 1) "Instr Name"
FROM student
WHERE INSTR(first_name,' ') < INSTR(first_name,'.')
AND INSTR(first_name,' ') <> 0
AND INSTR(first_name,'.') <> 0```
Computer Science & Information Technology
You might also like to view...
When you share a workbook with others, you control the collaboration process by using Excel's Track Changes feature
Indicate whether the statement is true or false
Computer Science & Information Technology
The _______ provides power from a battery to the computer during a power outage and during normal power conditions. (Give the acronym.)
Fill in the blank(s) with correct word
Computer Science & Information Technology