Tag: FUNCTION

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

MS SQL Server RIGHT() Function

Sometime you may need to determine right part of specific string in MS SQL Server. There is a function called RIGHT in MS SQL Server...

MS SQL Server LEN() Function

Sometime you may need to determine the length of your desired text in MS SQL Server. There is a function called LEN in MS SQL...