ASCII Characters

ASCII stands for American Standard Code for Information Interchange. ASCII code, was created in 1963 by the American Standards Association (ASA) Committee, the agency changed...

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