Options

AND?

ron2112ron2112 Posts: 3
edited January 17, 2011 6:44PM in SQL Search Previous Versions
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.
· Share on Twitter

Comments

  • Options
    krjoynerkrjoyner Posts: 3
    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.
    · Share on Twitter
  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    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
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.