Duration: 16:39 min
Summary: In this video, we will discuss the use of the ‘case statement’. The case statement is very powerful because it lets you make decisions as you are building your statement. It has a wide use within T-SQL. In our case, we will use the case statement to decide on what grade to assign and print out on the screen. Then, when we are retrieving data from the Product table, we are selecting a category base on the product line. We will also decide on a price range depending on a list price. All this case be done using the case statement while building the select statement.