Select Names NOT Starting And NOT Ending With Vowels in MS SQL Server

Introduction

Sometime we may need to select the column results that the string not starting and not ending with Vowels. In this article, We will have a look, How to select the columns results not starting and not ending with Vowels. In our previous articles we discussed how to select columns results 

• Select Names Starting With Vowels in MS SQL Server
• Select Names Ending With Vowels in MS SQL Server
• Select Names NOT Ending With Vowels in MS SQL Server

Example

As an example, we have a StudentDetails table, first lets select all the results from the table.

SELECT [StudentId]
      ,[FirstName]
      ,[LastName]
      ,[RegistrationNumber]
      ,[Degree]
      ,[CreatedDate]
      ,[CreatedBy]
  FROM [PracticalWorks].[Details].[StudentDetails]

Now lets select student names not starting and not ending with Vowels.

SELECT [StudentId]
      ,[FirstName]
      ,[LastName]
      ,[RegistrationNumber]
      ,[Degree]
      ,[CreatedDate]
      ,[CreatedBy]
  FROM [PracticalWorks].[Details].[StudentDetails] 
  WHERE [FirstName] NOT LIKE '[aeiou]%' 
  AND   [FirstName] NOT LIKE '%[aeiou]'

The above query results as,

Conclusion

In this article we have discussed about selecting the columns results not starting and not ending with Vowels. I hope you all found this article useful. Please share your feedback in the comment section.