SQL Server Education (by the geeks, for the geeks)
Alphanumeric string consists of alphabets and numbers for example a string 123xyz456abc is an alphanumeric string. Many a times it is required to extract only alphanumeric characters from a string excluding …
Function to parse alphanumeric characters from string in SQL Server Read MoreOne of the most common questions over forums is a SQL function to remove characters from string. The function for the same is given below. — Method 1: Loop IF(Object_id(‘dbo.fn_removecharactersfromstring’)) is …
SQL Function to remove characters from string Read MoreCHARINDEX and PATINDEX are used to get starting position of a pattern. The functional difference is that the PATINDEX can use wild characters in the pattern being searched whereas CHARINDEX can’t. …
charindex vs patindex performance comparison Read More