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 - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2012
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.