Information générale
Forum:
Microsoft SQL Server
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement