Practical SQL for Beginners Using Adventureworks Database Part 6 - How To Filter Text Using Wildcard

SQL is one of the fastest-growing programming languages. It is widely used by Data Analysts, Data scientists, Database Administrators, Backend Developers, etc.

As an aspiring Business Intelligence analyst and Data Analyst, you are often faced with data from different databases as against the conventional Excel files you learned building visualization with.

You will need to demonstrate a very good knowledge of SQL as business questions will be answered not just through the drag and drops Power BI environment but by demonstrating an understanding which addresses where the data required to answer this question resides in the database, how to retrieve it, what format must it be to be fit for the analysis, etc..

This is why you need to learn Structured Query Language. Business questions beget Queries.

As a beginner or intermediate learner, this series of videos will help you learn SQL in a practical way.

In this video, I walk you through how to Filter Text in SQL Using Wildcards.
Wildcards in SQL Query can be really helpful when working with Text. It allows you to filter text on several conditions.

[maydvicky]

I'm enjoying all your video's you made SQL so easy

[Wealth_Focus]

I love everything about your videos. I just want to say Thank You 💐

[emmanueloladipojohnson]

For the last question, I used this query

select distinct firstname from Person.Person
where firstname like '%[^ary]';

what do you think?

[collinvanleeuwen]

Thank you for the video's, they're very clear.
I do have a question though.

Why do you use _ instead of % when doing the 2nd and 4th questions?
In case of the 2nd question; If you use % you might find more names that end in 'ary' instead.

Or is my line of thinking wrong here? Looking forward to your answer.