* / Wildcard

<< .NET | IBExpert Glossary | Active tables >>

The asterisk (*) or so-called wildcard is used, for example, when selecting all or any data (or data sets) meeting a certain condition.

Example

 SELECT * FROM EMPLOYEE
 WHERE EMPLOYEE.PHONE_EXT='250';

All data sets containing the value 250 in the PHONE_EXT column in the EMPLOYEE table are fetched.

<< .NET | IBExpert Glossary | Active tables >>