Example of QBE query with joins, designed in Borland's Paradox database
Query by Example (QBE) is a database query language for relational databases.
SELECT*FROMContactsWHERECity='Sampleton'ANDZipcode='12345';More advanced versions of QBE have other comparison operator options, often via a pull-down menu, such as "Contains", "Not Contains", "Starts With", "Greater-Than", and so forth.
Another approach to text comparisons is to allow one or more wildcard character characters. For example, if an asterisk is designated as a wildcard character in a particular system, then searching for last names using "Rob*" would return (match) last names such as "Rob", "Robert", "Robertson", "Roberto", etc.
Contacts Query Form - Example C: .....Name: Rob* ..Address: .....City: ....State: ..Zipcode:Resulting SQL: