Built in string functions in sql server 2008 Part 22

In this video we will learn about the commonly used built-in string functions in SQL server 2008
1. ASCII(Character_Expression) – Returns the ASCII code of the given character expression.
2. CHAR(Integer_Expression) – Converts an int ASCII code to a character. The Integer_Expression, should be between 0 and 255.
3. LTRIM(Character_Expression) – Removes blanks on the left handside of the given character expression.

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1

4. RTRIM(Character_Expression) – Removes blanks on the right hand side of the given character expression.
5. LOWER(Character_Expression) – Converts all the characters in the given Character_Expression, to lowercase letters.
6. UPPER(Character_Expression) – Converts all the characters in the given Character_Expression, to uppercase letters.
7. REVERSE(‘Any_String_Expression’) – Reverses all the characters in the given string expression.
8. LEN(String_Expression) – Returns the count of total characters, in the given string expression, excluding the blanks at the end of the expression.

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/built-in-string-functions-in-sql-server.html

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-22-string-functions.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists