Tag: 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 NCHAR() Function

Sometimes you may need to convert an integer  value to an Unicode character in MS SQL Server. There is a function called NCHAR 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 ASCII Function

Sometimes you may need to convert character data to ASCII code value in MS SQL Server. There is a function called ASCII in MS SQL Server...

MS SQL Server LOWER() Function

Sometimes you may need to convert uppercase character data to lowercase in MS SQL Server. There is a function called LOWER in MS SQL Server...