SQL PUZZLE | Can you rewrite the LIKE using an IN condition? | SQL Interview Question

Here you need go through the sample T-SQL question and provide your answer based on the question asked.

Sample T-SQL

--

SELECT * FROM tableName WHERE colName = 10 OR colName = 11


--<strong>The above T-SQL can be rewritten as</strong>


SELECT * FROM tableName WHERE colName IN ( 10 , 11 )

--

Question – On the similar lines, you have to tell us how or can you rewrite the below statement using IN clause?

--

SELECT * FROM tableName WHERE colName LIKE '10%' OR  colName LIKE '11%'

--

Answer

Enjoy 🙂

Please add comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com