Select from List

D

Daiv

I am trying to build a query that will return the usernames that are not in a
specific list. The list is not coming from the same database so I need a
way to compare something like a comma delimited list to a query.

Is there a way to do this sql side?

Thanks.
 
S

Sergey Poberezovskiy

You could try something like
Select UserName from MyTable where UserName Not In ('use comma separated
list of user names from other source here')

HTH
 
Top