From the course: SQL Essential Training

Unlock the full course today

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

Separating text

Separating text - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

Separating text

“

- [Lecturer] In addition to joining or concatenating strings of text we can do the reverse of this which is to truncate or shorten a string of text. Now, we can achieve shortening or truncating a string of text by the use of understanding how text is stored in a text field. One important concept to understand is that text have positions in a stored field. So for instance, our first name field that has Frank the letter F sits in position number one and R two, A three, and so forth. Now this positioning matters when it comes to manipulating strings of text. Now, let's say our management at WSDA Music is really happy about our mailing list, however, they want to actually have a little more precise postal codes. If you notice, the current postal codes all have a dash and some numbers following and these numbers are usually referred to as the zip+4 code. And this isn't necessary for mail to find their way to the intended…

Contents