Can I use LIKE with IN?

I found this example of passing a list into a stored procedure:

where OrderList is something like "100,200,300,400".

What I want to do is find OrderID's that begin with any of the items in the list, so WHERE OrderID LIKE '100%' OR LIKE '200%' etc [WHERE OrderID LIKE IN...]. Is something like this possible?

Thanks.

re: Can I use LIKE with IN?

Read this

Happy Coding!!!


--- CK

re: Can I use LIKE with IN?

CK--

I read over the article, it seems like it was more about using REGEX and WILDCARDS. What I was trying to avoid was splitting the string apart and building a dynamic query. Like I said before I am going to pass in an array of about 6 numbers that the column might start with. The value is 28 digits long, I am going to pass in the first 4 or 5 digits, I want to pull all the records that match the set of the first 4 or 5 digits. Example:

Using the code below data will be (I want the columns <--):

@OrderList = (12345,54321)

CIF--------------------------------- OTHER COLUMN(S)
------------------------------------------------------------------------
1234500000000000045345 <--RETURN THIS
1234500008631362351351 <--RETURN THIS
9876834289374237423942
6566743234213123131312
5432100000000000023131 <--RETURN THIS
1234500000007637621369 <--RETURN THIS
5432108879796779697999 <--RETURN THIS
9410273734645535355355

Was there something I missed in the article?

Thanks,

Dan