>>Hi All,
>>
>>I have looked at the BOL, but it only shows one item per LIKE. Is this correct, or can you have multiple items per LIKE?
>>
>>I am trying to do an INLIST() in SQL Server. INLIST is partial matching, if you do not pad the items in the list. That is what I need to do now.
>>
>>Or, do I have to do fieldname LIKE 'A%' or fieldname LIKE 'D%' or fieldname LIKE 'Z%', etc?
>>
>>TIA
>>Beth
>
>You would have to constract it as myID like 'A%' or ....

That is what I was afraid of. :(

>
>If it's always one character you can use susbstring()/LEFT() and IN (...)
The user can enter in any number of alphanumeric characters and they may not be the same size for every entry.

thanks anyway.
Beth