John Hick

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.3 (67)

You rated this post out of 5. Change rating

2017-01-27 (first published: 2013-04-18)

39,376 reads

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

The more I work with the Data API Builder (DAB), the more I lean...

Comments posted to this topic are about the item Vector DB implementation using FAISS

Comments posted to this topic are about the item The Types of Changes

Comments posted to this topic are about the item Escaping Like I

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive

How many rows are returned by this code in SQL Server 2022?

select PlayerName from player
where playername like 'The\_C%' escape '\'