Select from List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daiv - 28 Dec 2005 21:09 GMT

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.

Reply to this Message

Sergey Poberezovskiy - 28 Dec 2005 22:01 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message