Posted by Driesen P via SQLMonster.com on 07/21/05 17:33

Sorry. I don't think that was clear. What I meant was I need something that
is similar to:

Select * from Security..SecUser
where UserId in (123, 456, 789)

The following query does not work:

Select * from Security..SecUser
where UserId like ('%123%', '%456%', '%789%')

Is there a query that can do this?

Thanks again

• Next in forum: Re: mmx.exe as encountered a problem and as to close
• Prev in forum: Newbie like question
• Thread view: Re: Newbie like question

[Reply to this message]