AnsweredAssumed Answered

SQL Selection Syntax

Question asked by Seidensticker on Feb 8, 2018
Latest reply on Feb 9, 2018 by Dan_Patterson

Anyone know if LIKE can be used with a list using wildcards in a selection query.  For example can the statement

NAICS_CODE LIKE '4233%' OR NAICS_CODE LIKE '5417%' 

be shortened to something similar to this

NAICS_CODE LIKE IN ( '4233%' , '5417%').

 

Reason being is that I have quite a few wildcard codes to add to the list and it would be more manageable.

Outcomes