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...
MS SQL Server CHAR() Function
Sometimes you may need to convert an integer ASCII value to a character in MS SQL Server. There is a function called CHAR in MS SQL...
MS SQL Server UPPER() Function
Sometimes you many need to convert lowercase character data to uppercase in MS SQL Server. There is a function called UPPER in MS SQL Server...
MS SQL Server LEFT() Function
Sometime you may need to determine left part of specific string in MS SQL Server. There is a function called LEFT in MS SQL Server...