Welcome to the Search Control v4 Demo!
 
This demo shows you how to build SQL queries and enable rich database search in your application in no time. Only task that developer needs to do is to choose wanted parameters according to his or her specific project requirements! 

If you have ANY question about this product please send us e-mail on info@beansoftware.com so we can help you. 

   
To try this demo you need to:
  1. Set search parameters using properties on the right side
  2. Write search terms in text box and click GetSQL button bellow



Returned SQL:
( album LIKE '%fast%' AND album LIKE '%superior%' AND album LIKE '%secure%' AND ( album LIKE '%database%' OR album LIKE '%website%' ) AND album LIKE '%search%' AND album NOT LIKE '%hard%' ) OR ( songlyrics LIKE '%fast%' AND songlyrics LIKE '%superior%' AND songlyrics LIKE '%secure%' AND ( songlyrics LIKE '%database%' OR songlyrics LIKE '%website%' ) AND songlyrics LIKE '%search%' AND songlyrics NOT LIKE '%hard%' ) OR ( songname LIKE '%fast%' AND songname LIKE '%superior%' AND songname LIKE '%secure%' AND ( songname LIKE '%database%' OR songname LIKE '%website%' ) AND songname LIKE '%search%' AND songname NOT LIKE '%hard%' ) OR ( writer LIKE '%fast%' AND writer LIKE '%superior%' AND writer LIKE '%secure%' AND ( writer LIKE '%database%' OR writer LIKE '%website%' ) AND writer LIKE '%search%' AND writer NOT LIKE '%hard%' )


     
Search Table Columns:





  Get It Now!

Property

Value

SQLSyntax
TypeOfSearch
WhereToSearch
WhatColumns
UseWildCards
MultipleWildCard
SingleWildCard
SearchingLogic
DefaultOperator
MinSearchWordLength
UseColumnsFilter
UseSpecialCharacters
UseBackslash
KeywordAND
KeywordOR
KeywordNOT
IfError
MaxSearchWordsNumber
NoiseWordsTemplate