>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 ....

If it's always one character you can use susbstring()/LEFT() and IN (...)