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
```
You might also like to view...
System requirements usually include all of the following, EXCEPT _____.
A. an operating system B. hard disk space C. memory D. a printer
When the width of the entire table is increased, the added space is divided evenly among the table columns.
Answer the following statement true (T) or false (F)
Access queries can be used interchangeably in Access and Excel
Indicate whether the statement is true or false
To sort data in a table, open it in Design View.
Answer the following statement true (T) or false (F)