SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

String Handling Functions - Part 1

String manipulation is a core skill for a DBA, so we're starting the series by looking at UPPER, LOWER, LEFT, RIGHT, LTRIM, and RTRIM. What happens if you try to use LOWER on a null? Or try to return a negative number of characters when doing a LEFT or RIGHT? The key is to learn how to use each of these functions individually, and then work on using them together in interesting combinations.

Duration:
6 mins 29 secs
Skill Level:
100
Rating:
4.31 out of 5
Publish Date:
October 11, 2010
String Handling Functions - Part 1 You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References



Comments
Stéphane Thinel on 10/11/2010
I love that you took the time to show an exemple of all the options you talked about

Albert on 10/11/2010
easy to understand, facil de ententer

Rimjim on 10/11/2010
very clear and informative...look forward to the next lesson

Jamshid Nouri on 10/11/2010
excellent demo

Dennis Allen on 10/11/2010
looking forward to talking about different parsing techniques. I've read quite a bit about T-SQL techniques, and I am just getting started with my first CLR functions, and I hope you can talk about those in comparison. Additionally, I would like to see more with good uses of CLR procedures. Currently I am looking to a CLR function to allow parallel execution of sub-processes in a reporting procedure that in T-SQL is of course single-threaded but the 12 (cpu intensive) sub-procedures could be executed in parallel and in makes sense to do so on the 16-core server.

Yelena on 10/11/2010
Thanks for making this avalable

srydzews on 10/11/2010
super basic, but clear!

dfortier on 10/11/2010
p

Brent Templeton on 10/11/2010
thanks

Charlie Bruno on 10/11/2010
Good basic demo, as usual...

Rod on 10/11/2010
I wasn't aware of the trim functions, so this is very good! The only question I have, is what version of SQL Server does this work for?

neeta on 10/11/2010
It was good. There was quite a bit of beginner information, that I needed. Thank you.

manjeet on 10/11/2010
nice for starter

manjeet on 10/11/2010
nice for starter

manjeet on 10/11/2010
nice for starter

manjeet on 10/11/2010
nice for starter

suyog kandi on 10/11/2010
Was very basic level

suyog kandi on 10/11/2010
Was very basic level

kalapala baburao on 10/11/2010
ok

kalapala baburao on 10/11/2010
ok

Mohamed Irshad on 10/12/2010
excellent

Kenneth Wymore on 10/12/2010
good beginner video! I look forward to the ones for the rest of the week.

WChaster on 10/12/2010
I knew that, I just do not get to use this much. Why doest-SQL not have a TRIM ALL anyway?

Diana Dee on 10/12/2010
It would be nice if the code being executed were positioned so it remains above the result pane after execution. Thanks for listening! (sic)

Steve Culshaw on 10/14/2010
Good overview on string

Venky Subramaniam on 10/14/2010
Excellent, patient demo that is very useful for a T-SQL beginner...

A Alagu Ganesh on 10/15/2010
Good

A Alagu Ganesh on 10/15/2010
Good

Margie on 10/15/2010
Always good to learn from Andy.

Manuel A. Rodriguez on 10/17/2010
Like Andy says...this is definitely something every DBA should know.

race on 10/27/2010
What of performance information on using each of those functions? I am looking at a situation where I loop through every string in a list of maybe 10000 sent from the client to the database. Would like to manipulate those in the db before saving final for each.

Steve Ramp on 10/30/2010
ltrimrtrim combo very useful

Oddvar Eikli on 11/1/2010
It might be a good idea to scroll down a bit in the code window before executing statements so that executed code is in the top half of the window and thus remains visible above the result panel after execution.

Kat on 11/5/2010
I really enjoy his videos. They are clear, to the point, and good examples.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions