From the course: SQL Essential Training

Unlock the full course today

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

Connecting strings

Connecting strings - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

Connecting strings

“

- [Instructor] Now, to demonstrate the use of string functions, we can take a look at the following scenario. Now, let's say our managerial team at WSDA Music is interested in sending out personalized postcards to each one of their US-based customers. Now, to do this, we would need a single field that comprises of the customer's first name, last name, address and that would be their full address which would include the street, the city, the state, and the zip code. Let's see how we could use our SQL string functions to build this field. Now, when it comes to joining separate fields, this is referred to as concatenating them in SQL. And to achieve this, we use the double pipe operator in SQLite. I'm going to make a quick single line comment just to demonstrate that the double pipe is just simply the pipe symbol on your keyboard two times. Okay, now let's start to build our new field which is going to be our mailing address.…

Contents