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). (7 rows).
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...
Auto ________ is an Excel feature that can generate a series of values into adjacent cells
Fill in the blank(s) with correct word
Computer Science & Information Technology
You need to ________ an image in Google Images in order to copy it to your computer
A) double-click B) triple-click C) right-click D) left-click
Computer Science & Information Technology