VMS Live applications Swiftbase
Home | Live Demo's | Search Engine | Products | Utilities | Government | Hardware | Faqs | Contact | Links

Roger - web developer
 Wildcards      * %


Two methods of basic wildcarding are provided for, single character and the multi character substitution.

The % percent is used to specify a single character replacement and is a great way to deal with items such as part numbers or stock numbers. For example say your part numbers are in the format of 3-5-3 where it's make-item#-version.
In this case you can specify a search for all version 1 items for make cobra like this COB-%%%%%-001.

Of course the second wild card would work just as well in this case, it's an * asterix. This tells the system to ignore any number of characters but in it's case is most oftern used on the tail of a word, commonly to resove plaualising problems for example if you wanted a red car you might be better looking 'red car*' to get cars as well as car.

Both can be used as oftern as you want and mixed up together in the same word, for example c*van% would find all caravans.

Wildcards are also usefull when used with a couple of words to shorten the search string for example on a contact management system (CRM) you might search for Mart* Ban* - on a contact management system this will get you all the Martins that work in Banks.
Its also worth pointing out that there is no case sensitivity at all in this product.