Impossible Joins … unless you use STRING_SPLIT() | Essential SQL

Learn how to do an impossible join using STRING_SPLIT. Learn to join on dirty data, by tokenizing a column. That is splitting it into words, which you can then join to other tables. This is useful if those pesky humans have entered extraneous data around project codes, or other data you wish to relate. For example, in one table you have “ABC12” and in another “PRE ABC12 (RED)” Seems like an impossible join, until you look at the values and see you can split up the once column into three separate words! One Last Thing... This video is part of my Beginner Learning series. If you're interested in learning SQL subscribe to @Essential SQL and then check out our Intermediate Learner Playlist. Of course, I also encourage you to visit https://www.essentialsql.com to learn even more! Source Code: -- Project create table Project ( id int, ProjectName varchar(40), AccountNumber varchar(20) ) insert into Project