Category: Data Engineering

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

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