The challenge is to implement similarly functionality in TSQL, that works similar to TRANSLATE function of ORACLE.

This challenge to is implement similarly functionality in TSQL, that works similar to INITCAP function of ORACLE.

This challenge deals with String aggregation. On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value.

Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL.

Here is a TSQL challenge to build a well formed HTML fragment from a comma separated list of HTML tags provided as input.

This challenge involves counting the number of occurrences of HTML tags in a given list of strings. You can assume that there will be only valid HTML tags in the input strings. The output should display tags in ascending order.

This problem is all about identifying all the employees directly or indirectly to whom the given Employee reports to. The challenge is to write a query that can take a Employee Id as a parameter and list all the employees to whom the Employee is reporting, directly or indirectly.

This challenge is to find the palindromic words from sentence(s). While finding the palindromic words from the sentence(s), the noise words should be removed if any is present in the sentence.

This challenge is to reverse the order of words within a sentence.

This challenge is all about counting the number of occurrence of characters in a string using a SET based query. The task is to list all the characters and count of that character within the given string.