SQL Server string Common functions

1. Left returns the number of characters in the string that are specified in the beginning.
SELECT left (' ABCDEFG ', 2);----AB2. Right returns the specified number of characters in the string starting from the left.SELECT Right (' ABCDEFG ', 2);----FG3.LEN return string lengthSELECT LEN (' ABCDEFG ');
----7SELECT LEN (' ABCDEFG ');
----8SELECT LEN (' a bcdefg ');
----8SELECT LEN (' ABCDEFG ');
----74.LOWER returns the lowercase form of an uppercase stringSELECT LOWER (' ABCDEFG ');
----ABCDEFG5.UPPER returns the uppercase form of a lowercase stringSELECT UPPER (' ABCDEFG ');
----ABCDEFG6.LTRIM returns the left whitespace form of the stripped stringSELECT LTRIM (' ABCDEFG ');
----ABCDEFG

SQL Server string Common functions