All right.
Moving along to the next function, which is reverse and reverse does what it sounds like.
It reverses strings.
That's why I said it's super straight forward, you know, forward.
Reverse.
It's a joke.
Yep.
So that's what it does.
It will reverse a string.
So here's an example.
Select reverse of Hello World and we get this row.
Ola.
I think it's probably best if I just stop pronouncing them from here on out, but you get the reversed
version of the string, same casing and everything.
Same spaces just reversed.
And that's kind of all there is to it, to be honest.
I'll show you a couple of examples.
But if you feel like you already have a that was enough for you and you understand how it works and
feel free to just move on.
But I'll go over to Cloud Nine and show a couple of examples.
So let's do a select reverse and instead of Hello World, let's just do Meow Meow.
Why not just like that?
And we get what I said, I wouldn't pronounce them.
Well, we get this right here reversed of meow meow.
So we could do the same thing to find the reverse of every author's first name in our table, for instance.
So that would be a select reverse author f name, and then from books.
And there we go.
We get the reverse of Jhumpa, the reverse of Neil, and so on.
And that's kind of it.
And just like some of these other ones, we can combine them.
So if I wanted to turn something into a palindrome, for instance, let's say I started with the string
woof.
And if you're not familiar, a palindrome is something that reads the same forwards and backwards.
So the way I would do that is by adding f0w to that and concatenating them.
So taking the original string plus the reverse string and concatenating them.
So we have two functions.
We've seen how to do that and it's just a matter of cat, so a select can cat and we'll just start with
Woof and then what do we want to concatenate it with?
Well, we want to concatenate it with the reverse of woof.
Just like that.
And that should do it.
Let's try it out.
And we get this the palindrome version, I guess, that we just made this sandwich.
Now let's just try it with authors first names again.
So let's do that now.
All we need to do is replace a couple of things in here.
So rather than concluding, woof, we're going to do author f name, and then we're going to use the
reverse of author f name as well.
Just like that.
And then, of course, we need to say from where?
From books.
Let's copy that.
So just again, we're taking the author's first name, the reverse of the author's first name, and
we're smashing them together with Cat.
And there we go.
We get.
This one's kind of funny, I guess.
David Devore.
DD And I don't think any of them are really pronounceable otherwise.
But they are valid palindromes.
So I guess we succeeded at something.