Red Gate forums :: View topic - AND?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

AND?

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ron2112



Joined: 03 Feb 2010
Posts: 2

PostPosted: Wed Feb 03, 2010 1:56 pm    Post subject: AND? Reply with quote

Great tool! I think I can probably stop using SQL HelpBuilder now!

The search seems to do an OR if you enter multiple search terms. Putting AND between the terms simply treats it as the word "and". Is there any way of doing an AND search?

Ron Moses
_________________
---------
Avoid infestation. Rotate.
Back to top
View user's profile Send private message
krjoyner



Joined: 17 Jan 2011
Posts: 2

PostPosted: Mon Jan 17, 2011 9:55 pm    Post subject: i wish it could do an OR Reply with quote

You sure you're describing it right? When I type in two strings it does an AND search. Such as "APPLE ORANGE" gets me all results where both apple and orange are in the metadata. However I can not get it to do an OR so that i get all results whether they have either APPLE or ORANGE.

This would be a good feature to add since I need to be able to search for multiple hard coded numeric values, sometimes in the hundreds.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Tue Jan 18, 2011 12:44 am    Post subject: Reply with quote

Yes, you're right - it won't do OR yet.

Your only option is to do each search individually, and maybe copy and paste the results into excel if you need to aggregate them.

Thanks for the request!

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group