From the course: SQL Essential Training

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

UPPER and LOWER string functions

UPPER and LOWER string functions - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

UPPER and LOWER string functions

“

- [Instructor] So, let's take a look at a couple more string functions that will be pretty helpful to know. First, let's take a look at the UPPER function, and the UPPER function simply takes a string of text and converts it to upper case. So, let's take the FirstName field and make this field upper case. So, just simply putting the field name between the parenthesis of the upper function let's make sure and include our extra comma to accommodate this new field, and let's even alias this to call it First Name All caps. Now, let's run this newly updated statement. We have our new field First Name All caps, and if you take a look at the contents, it now has all of our first names in upper case, and we can verify the original value in our FirstName field here and in now newly updated uppercase values. Okay, one more string function which is the opposite of UPPER, which is LOWER. The LOWER function simply converts a string…

Contents