Select Names NOT Ending With Vowels in MS SQL Server

Introduction

In this article, We will have a look, How to select the columns results NOT ending with Vowels. In our previous articles we discussed how to select columns results starting with vowels and column results ending with vowels.

• Select Names Starting With Vowels in MS SQL Server
• Select Names 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] 

The above query’s result is as shown below,

Now lets select student names NOT ENDING with Vowels.

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

Conclusion

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