MS SQL Server PATINDEX() Function
Sometimes you may need to delete specific characters in one string by inserting another specific length of string in MS SQL Server. There is a...
MS SQL Server SPACE() Function
Sometimes you may need to add space with your desired text in MS SQL Server. There is a function called SPACE in MS SQL Server by...
MS SQL Server STRING_ESCAPE() Function
Sometimes you may need to create JSON text from variables and escapes any special JSON character in variables in MS SQL Server. There is a...
MS SQL Server STRING_AGG() Function
Sometimes you may need to aggregate cell values of multiple rows in MS SQL Server. There is a function called STRING_AGG in MS SQL Server by...
MS SQL Server STUFF() Function
Sometimes you may need to delete specific characters in one string by inserting another specific length of string in MS SQL Server. There is a...
MS SQL Server TRIM() Function
Sometimes there may be want to remove unwanted space or other character from a string or field in MS SQL Server. There is a function...