From the course: Querying Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Filtering text

Filtering text - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2012

Start my 1-month free trial

Filtering text

In the previous lesson, introducing the WHERE clause, we saw the basics of providing filtering in your queries by using logical operators such as equal to or greater than, and ranges such as IN and BETWEEN. In this lesson, we're going to take a look at expanding on what the WHERE clause allows us to filter through the use of text filtering capabilities within SQL Server. In our Sequel Server management studio, we have a number of queries that we'll execute in, they'll show the different aspects of some text filtering capabilities built into the Sequel language. In our first query, we are going to execute a where clause and return only records from the employees table, where the employees are a manager of some type. So we're not exactly sure maybe what the different types of managers are in this particular database although we could look them up, but we do know that in the job title, manager would be specified if they are some type of a manager. So, we're going to execute a query that…

Contents