Select from List

  • Thread starter Thread starter Guest
  • Start date Start date
G

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