Category: Tech Tips & Tricks

MS SQL Server REPLACE() Function

Sometimes you may need to replace all occurrences of a specific string with another string value in MS SQL Server. There is a function called...

MS SQL Server CHARINDEX() Function

Sometimes you may need to find the starting index or position of your specific expression into another expression in MS SQL Server. There is a...

MS SQL Server REVERSE() Function

Sometimes you may need to work with specific part of a expression in MS SQL Server. There is a function called REVERSE in MS SQL...

MS SQL Server SUBSTRING() Function

Sometimes you may need to work with specific part of a expression in MS SQL Server. There is a function called SUBSTRING in MS SQL Server...

MS SQL Server STRING_SPLIT() Function

Sometimes you may need to split a tags value of column level  into row level  in MS SQL Server. There is a function called STRING_SPLIT...

MS SQL Server UNICODE() Function

Sometimes you may need to determine the integer value of an Unicode character  in MS SQL Server. There is a function called UNICODE in MS...