Better alternative to SQL "or" statement in 'Where' clause when dealing with lists?

Question

Super simple question coming from someone very new to SQL. I have a list of about 30 zip codes (below) stored in an excel file. What I want to do is figure out the most efficient way to get the zip codes listed below into my where statement to filter on JUST the '30' without having to say:

WHERE o.strPostalCodeNode = 00501 or 00544 or...

If this list was larger, this "or" approach wouldn't be a feasible solution. There must be an obvious, better way to do this!

Here are the zips:

On a sidenote: you'd better not use `WHERE o.strPostalCodeNode = 00501 or 00544 or...` anyway, but rather `WHERE o.strPostalCodeNode = 00501 or o.strPostalCodeNode = 00544 or...` :-) — Thorsten Kettner, Aug 03 '18 at 16:39

score 0 · Answer 1 · answered Aug 03 '18 at 16:27

use in operator that already said in comment

     select * from yourtable 
        where strPostalCodeNode  in(00501,
00544,
06390,
11701,
11702,
11703,
11704,
11705,
11706,
11707,
11708,
11713,
11715,
11716,
11717,
11718,
11719,
11720,
11721,
11722,
11724,
11725,
11726,
11727,
11729,
11730,
11731,
11733,
11738,
11739,
11740,
11741,
11742,
11743,
11746,
11747,
11749,
11750,
11751,
11752,
11754,
11755,
11757,
11760,
11763,
11764,
11766,
11767,
11768,
11769,
11770,
11772,
11775,
11776,
11777,
11778,
11779,
11780,
11782,
11784,
11786,
11787,
11788,
11789,
11790,
11792,
11794,
11795,
11796,
11798,
11901,
11930,
11931,
11932,
11933,
11934,
11935,
11937,
11939,
11940,
11941,
11942,
11944,
11946,
11947,
11948,
11949,
11950,
11951,
11952,
11953,
11954,
11955,
11956,
11957,
11958,
11959,
11960,
11961,
11962,
11963,
11964,
11965,
11967,
11968,
11969,
11970,
11971,
11972,
11973,
11975,
11976,
11977,
11978,
11980,
11542,
11771,
11791,
11561,
11510)

Better alternative to SQL "or" statement in 'Where' clause when dealing with lists?

1 Answers1