4D v13.4

search_condition

Home

 
4D v13.4
search_condition

search_condition  


 

 

Command search_conditiopredicate |

NOT search_condition |

(search_condition) |

search_condition OR search_condition |

search_condition AND search_condition |

A search_condition specifies a condition to be applied to the data retrieved. A combination of search conditions using AND or OR keywords can also be applied. You can also precede a search_condition with the NOT keyword in order to retrieve data that does not meet the specified condition.

It is also possible to pass a predicate as a search_condition.

Example  

Here is an example using a combination of search conditions in the WHERE clause:

SELECT supplier_id
FROM suppliers
WHERE (name = 'CANON')
OR (name = 'Hewlett Packard' AND city = 'New York')
OR (name = 'Firewall' AND status = 'Closed' AND city = 'Chicago');

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

DELETE
predicate
SELECT
UPDATE