SQL Server using wildcard within IN May 3, 2023 by Tarik How about: WHERE LEFT(job_no, 4) IN ('0711', '0712', ...)