You could try the opposite approach: "12345,23456,98745" LIKE "%"+ 'Account ID + "%"
Dwayne Martin James Madison University -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 12, 2010 12:58 PM To: [email protected] Subject: Re: Query format question Advanced Query does not accept the db "IN" statement which would allow 'Account ID' IN (12345,23456,98745) You have to do 'Account ID' = xxx OR 'Account ID' = yyy ... Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Wednesday, May 12, 2010 11:40 AM To: [email protected] Subject: Query format question ** HI All I would like to do an Advanced Search query on a group of records based on the Account ID. I could do 'Account ID' = 12345 OR 'Account ID' = 23456 OR 'Account ID' = 98745 OR .... But I was thinking I could do something like 'Account ID' = 12345;23456;98745 but I can't get the format right. Anyone know the right syntax? Thanks Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite [email protected] (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
