Category: Data Analytics

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

MS SQL Server String Related Functions

Sometimes you may need to process some strings to get your desired result. There are some built-in string related functions in MS SQL Server which...