TurboDB Engine Documentation
Search-Conditions
See also
Previous  Top  Next


Search-Conditions are Boolean expression like in SQL or in Pascal. These are some examples of TurboDB search-conditions:

Name is 'Smith'
Name = "Smith"
Name like 'Smi*'
Name like 'Smit?'
Name has "mit"
Name[3] = 'i'
LeftStr(Name, 2) = "Sm"
Length(Name) > 4
Amount = 13546.45
Amount less 13546.46
Amount < 345,67 or Amount > 567,89
Amount1 * 0.3 > Amount2 * 0.8
Date-of-birth = 20/4/1962
Date-of-birth < 20/4/1962
Date-of-birth from 4/1/1962 upto 4/30/1962
Year(Date-of-birth) < Year(Now)


Name, Amount, Amount1, Amount2 and Date-of-birth are table columns. Single and double quotes can be used equally. * is a joker for zero or more arbitrary characters, ? is the joker for exactly one character. TurboDB offers powerful functions and operators for use in search-conditions, e.g. like, from...upto, LeftStr, Year and many others. Refer to Operators and Functions for a complete reference. Comparisons can be combined using the logical operators and, or and not.