WHILE Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

SQL Function to remove characters from string

December 19, 2014December 20, 2019 - by SQL Geek - Leave a Comment

One 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 Server / SQL Server Accidental DBA Series

SQL function to extract number from string

November 23, 2014December 20, 2019 - by SQL Geek - 1 Comment

A common question among forum is a SQL function to extract number from string. Let’s see how this can be achieved. One way to achieve this is with while loop as …