This is possible by using the combination of PATINDEX() and STUFF() functions. Step 1: Declare a Parameter and Store the string in it. Step 2: Search for Alphanumeric characters from the string by using PATINDEX. If exists, just loop the following statements.

Read More