SQL SERVER – Reverse String Word By Word – Part 4
SQL SERVER – Reverse String Word By Word – Part 3
SQL SERVER – Reverse String Word By Word – Part 2
SQL SERVER – Reverse String Word By Word
SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick
I hardly get hard time to come up with the title of the blog post. This was one of the blog post even though simple, I believe I have not come up with appropriate title: Group by Rows and Columns using XML PATH – Efficient Concating Trick. Anyway, here is the question I received.
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
One of my friends who works in a big MNC recently asked me that if there is any way to check if the String is Palindrome or not. The palindrome is a word, phrase, or sequence that reads the same backward as forward. For example A man, a plan, a canal – Panama! is palindrome so as Was it a car or a cat I saw?
My first reaction was to him was why does this kind of functionality. His answer was they have requirement in their business application where they are building captcha and they may display the image in mirror image as well as a part of challenge code and he can’t have any word which is palindrome as an option. For this he wanted to write a script which will go letter by letter and match them. If they are same, he will not use the word for captcha.