From the course: Microsoft SQL Server 2016: Query Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Queries using character functions - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Queries using character functions
- [Instructor] In this lesson, we're going to take a look at some functions that operate on character data. Some of them we've already seen before but they'll be a great review and then others we'll come across you haven't maybe seen yet, or we certainly haven't covered in this course yet. And they're all examples of functions that allow us to work with and manipulate character data in our SQL server databases. We've seen concatenations so this first couple of queries will just show an example of concatenation, once again, in some of the different ways that we work with concatenation. Again, remember that the addition symbol or the plus symbol is the concatenation symbol that SQL server uses. So in our first query, we're going to select the first name and the last name from our person table. And we're going to concatenate the two of them together into a column aliased as full name, and we're going to separate them with the space. So that's this whole section right here. That…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.