Built in string functions in sql server 2008 Part 22
Vložit
- čas přidán 25. 07. 2024
- 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 CZcams channel. Hope you can help.
/ @aarvikitchen5572
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
csharp-video-tutorials.blogspo...
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
czcams.com/users/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic
Really helpful video thank you! So glad I found this channel :)
even though i'm from non it background i can easily write codes becz of venkat thank u vry much sir
Very educative videos, You are the best at simplifying difficult concepts
Amazing Lecture Thank you so much, simple words and understandable. God bless you!
the way u explain...................i love it...........u make every topic so sosososososo
easy...
You are the best Sir..
I am learning so many topics from Your teaching .. thank you sir
very useful for string manipulations
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 =)
Thanks Venkat
Very well explained. Thank you so much
Thank You Sir
Very helpful Video..Very Nice Sir
Revisiting
Thanks
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
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 ?
thank u sir
Excellent videos and really very helpful sir....do u have any video for Merge Concepts in Sql Server ?
I have just a question. Do the LTRIM and RTRIM change the original data or only create a copy without the blank spaces?
can you make java full video length tutorial.
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?
hello at first thank you sir
please can you send a link to download this database that you work on SQL
LTRIM(FIRSTNAME) -firstname is in capital which is not same as the table name.How did it work ? Is not case sensitive.?
can any one help me with two things
1) at 7:01 it is said that ASCII of 0 however in the starting it is said that it accepts a character and returns integer .
2) at 11:45 sir uses right trim(left trim) on firstname only in brackets how did it trim the spaces between first and middle name since it would have been done if it was applied after concatenating.
thank you for your response
May be you already have figured it out. But anyway as it says in the start which you also mentioned ASCII accepts character so he placed the zero(which is a integer) between the single columns to make it character. Hope that helps.
Which command will work for all characters in proper case in SQL
where can we get the database tables that you use?
Hello. How to extract a last three elements from string, my string is | seperated
Your videos r really assets 10 years old still no match of your teaching.
Can any one explain how to display first_name and last_name
I trust you 10:00
why A start with 65 code?
it can also be achieved by this(for printing small letters)
Declare @start int
set @start=97
Declare @count int
set @count=1
While (@count
Hi Gurjar nice thinking first we declare ASCII value of small letter then u declare count of each letter separately and write a while loop for that count not for @start finally u print the @start values is my understanding is correct
are u open course vb.net?
DECLARE is not valid at this position