From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution: Play with strings

Solution: Play with strings - SQL Tutorial

From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Start my 1-month free trial Buy for my team

Solution: Play with strings

“

(upbeat music) - [Instructor] Let's first see how the tags looks like. I will say select * from products. And it specifically, let's say, select tags from the products. You can see that this is not looking correct. All of them are look like in a lower case. So to change this, we just say that initcap. So there is a function called initcap that will make the first letter as a capital one. Now, if I execute this again, you will see Electronics, Portable, Tech, all the words' first letter is coming as capital.

Contents