Tag: STRING

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...

MS SQL Server CONCAT_WS() Function

Sometimes you may need to concatenate or join multiple strings with decimetre  in MS SQL Server. There is a function called CONCAT_WS in MS SQL Server...

MS SQL Server CONCAT() Function

Sometimes you may need to concatenate or join multiple strings in MS SQL Server. There is a function called CONCAT in MS SQL Server by which...

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...