Dividing a Column into Multiple Ranges Using Conditional Aggregation in SQL

How to Search for a String Value in All Columns of a Table with Case-Insensitive Matching Using Dynamic SQL in SQL Server