And this video, we're going to display the first name, last name of the employee, which contained
a letter C in their last name at third grade, a position.
To do that, let's examine the data first, select firsts first name.
Last name.
From employees.
Got the first name, last name coming up, and we are interested in people where they contain the letter
C. initially, but later on we're going to see we only one those people who has the letter C in their
third or get position.
First of all, let's look at the people, which contains a literacy at all to do that.
There are several methods to do that.
We can use the like function, we can use position function.
So over here, let's look at the position function position requires to provide a string that you are
looking for.
So we are looking at a string in what is the main string, which is a column.
So we're going to say a last name.
And let's run it, for example, like Alexander Honold, there is no capital C in the last name or Earnest's
or Austin Patiala, so that's why we get the position as in zero.
So if you scroll down, you get the Jerral Campbell, which have a capital C in the last name, and
Karen and Annett all coming up with a position number one.
So the this shows that the letter C appears in the position number one, position number one.
Now what we need is only the records fed by the literacy position is greater than three equal to or
greater than three.
If you're going to do is we will do a better position.
And less to see in last last name.
Great then to say we won either a three or greater.
So if you do it great then to or we can do a greater than an equal to three.
It will produce the same results.
So let's run it.
And we get the only one record, which is Samuel McCain.
And NMCC, this is the third position whereby the capital letter C is coming up.
So opposition function is pretty handy tool to do a lot of string manipulation like that in your database.