Select from List

[Guest]

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.

 

[Guest]

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