The CASE statement


It seems like the CASE statement can be used anywhere. But where does it make sense to use the CASE statement? What are alternatives and are the alternatives better or worse? We'll cover:
  • Basic syntax
  • What it can't do
  • Common uses
  • Unexpected uses
  • Benefits
  • Alternatives for various uses


  • Mike Burek

    16 Recordings
    Mike Burek has worked with SQL Server for 25 years. Throughout his career, he has often worked with marketing data. From this, he has experience with various tools for ETL as the industry and programming has changed and matured over time. On the SQL Server side, he has held senior positions in database administration and database programming, focusing on optimization, automation, and increasing the value of data. Outside of work, he also runs the Austin SQL Server user group and makes a big effort to train others to help them grow in their careers.

Recorded At:

Recorded on:

Jun 16, 2021

More Info:


  • SQL 28 Recordings