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.

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

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[poshpoise]

the way u love make every topic so sosososososo
easy...

[ravigasi]

I am learning so many topics from Your teaching .. thank you sir

[priyadarshini]

even though i'm from non it background i can easily write codes becz of venkat thank u vry much sir

[mulebelay]

Amazing Lecture Thank you so much, simple words and understandable. God bless you!

[edwardmwai]

Very educative videos, You are the best at simplifying difficult concepts

[amardeep]

hey venkta could u pls little zoom queries text becoz it really difficult to see for visual handicap student... i truly like ur channel.. amd meticulously follow this

[rasikadhanapala]

Very well explained. Thank you so much

[Ventr]

Excellent and i enjoyed it. It was mildly confusing that the AS names of first and last name was the same as the orignial, when you created the full name. But figured it out =)

[karthikp]

Excellent videos and really very helpful sir....do u have any video for Merge Concepts in Sql Server ?

[programmeseekho]

Thank You Sir
Very helpful Video..Very Nice Sir

[spatterson]

Really helpful video thank you! So glad I found this channel :)

[jitendrapadsala]

this tutorials helps a lot to beginers .
thank you very much sir .
i have a question
all queries work in visual studio as i type same as you show in video ?

[sunilrawat]

Your videos r really assets 10 years old still no match of your teaching.

[KadwaSach]

can you make java full video length tutorial.

[manuelhumbertocastrodiaz]

I have just a question. Do the LTRIM and RTRIM change the original data or only create a copy without the blank spaces?

[TheHossam]

hello at first thank you sir
please can you send a link to download this database that you work on SQL

[VirendraSingh-gylr]

Which command will work for all characters in proper case in SQL

[mappalaraju]

LTRIM(FIRSTNAME) -firstname is in capital which is not same as the table name.How did it work ? Is not case sensitive.?

[sitaramakella]

how could we strip html tags from a text column? I tried Replace function .the problem is need to use multiple Replace function calls for each of the tag.
Is there any efficient way to implement this?

[BornDude]

it can also be achieved by this(for printing small letters)

Declare @start int
set @start=97
Declare @count int
set @count=1
begin

end