If your sql server is installed with the default collation of case-insensitive, you can accomplish this in sql instead.

You can determine if your installation collation is case-insensitive by running this query:

SELECT SERVERPROPERTY ('Collation')
GO

If the result is Collate SQL_Latin1_General_CP1_CI_AS, then it it is case-insensitive.

For example, I may have data stored in column as AbC and ABC. I want only rows where the column = ‘AbC’

You can accomplish this by using the Collate method in sql to tell your installation that you want to override the default property with the case-sensitive property like this (SQL_Latin1_General_CP1_CS_AS):

Let’s say you have a column in a table that is comma delimited. The value in the column is ‘APPLE, ORANGE, GRAPE’. You want to break down this string value into individual rows. You may also want to create an auto-incremented IDENTITY column too. Here is one way it can be done.