Article ID: 205231 - View products that this article applies to.
This article was previously published under Q205231
For a Microsoft FrontPage 98 version of this article, see 194677
For a Microsoft FrontPage 97 version of this article, see 190621
This article describes how to search a database using the LIKE parameter in a Structured Query Language (SQL) statement in the Database Results Wizard of Microsoft FrontPage.
This article assumes that you have a basic knowledge of how to query a database using Active Server Pages (ASP) technologies in FrontPage.
When used in a search, the LIKE clause in SQL can be used to generate a result set based on a minimum amount of information typed into the form field of a Hypertext Markup Language (HTML) form. For example, if you type mic% in the form field, the results may include Microsoft, microphone, microwave, and so forth.
To use the Database Results Wizard to specify what you want to compare, follow thse steps:
If you browse to the page and enter Sales Manager, you will see only those records that exactly matched the search string. If you enter Sales%, you will see all records that begin with the word Sales. The resulting SQL used by this query would be:
The precent sign is a wildcard character so that the LIKE string can match multiple records.
NOTE: When you first browse the page or if the form field is blank when you submit the form, no records from the database will be returned. However, you can enter a value of a single precent sign and all records will be returned.
For additional information about SQL queries and FrontPage, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/306430/EN-US/ )FP: SQL Syntax Generated by the FrontPage Database Results Wizard
Article ID: 205231 - Last Review: January 23, 2007 - Revision: 3.2