#Now if you have values that have white space on the front or end, we can get rid of that white space using TRIM SELECT TRIM('sky' ); #Now if we have white space in the middle it doesn't work SELECT ...

#Now we have Left. Left is going to allow us to take a certain amount of strings from the left hand side. #Now let's look at substring, this one I personally love and use a lot. #Substring allows you ...