我正在尝试从学生表中检索以辅音开头和结尾的名称。我正在尝试写
SELECT NAME
FROM STUDENT
WHERE NAME-LEFT(NAME,1) IN ('A','E','I','O','U')
AND NAME-RIGHT(NAME,1) IN ('A','E','I','O','U');
试图省略元音的词条，然后其余词条自动变成辅音，但我认为SQL查询中有一个错误，因为我也得到了以元音开头的词条。如何解决此问题？
SELECT NAME
FROM STUDENT
WHERE LEFT(UPPER(NAME),1) NOT IN ('A','E','I','O','U') /*change done is to extract the first letter*/
AND RIGHT(UPPER(NAME),1) NOT IN ('A','E','I','O','U'); /*change done is to extract the last letter*/
编辑：根据Akina的反馈，添加了迎合非元音的条件，并假设排序特征与匹配