Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  need help with search terms

Author  Topic  Kagari Starting Member 1 Post Posted - 2013-12-30 : 07:49:06 For the above search i need to run it so that people in both 'batchid - 201401PRE' & 'batchid - 201401IRC' will show up only. Tried using And i got not results. using 'Or' just shows people in either list. my condition must be that the people in both list to turn up in the search result. Thanks. Kag