|
|
|
|
|
Nearly all possible text string searches are supported in Servoy.
To find a text string:
A text search can be:
For example, if you search for Hotel only rows matching Hotel will be returned. Rows containing hotel or Nice Hotel will not be returned.
To search case insensitive, use a # symbol in front of your
search criteria.
As an example, if you search for #hotel rows matching hotel, HOTEL and Hotel will be returned.
By default, a case insensitive equisearch (exact match) is performed for optimal performance.
Wildcards
A wildcard character %, representing one or more unknown characters, can be used in your search request.
To escape wildcards - use the literal wildcard symbol in your search criteria - type a backslash "\" in front of the wildcard character. For example \% will search for the character %.
Null values
A NULL value character ^, representing a NULL (not existing) value, can also be used in your search request.
Below is a list of text search possibilities:
To find |
Enter this |
Example |
|---|---|---|
Field data that is dependent on casing (case sensitive) |
characters that match in casing |
Hotel will return only records that match Hotel; not hotel |
Field data that is independent of casing (case insensitive) |
#characters |
#hotel will return records that match hotel, HOTEL, Hotel |
Field data that starts with specific characters |
the characters followed by % |
B% will return records that start with an uppercase B |
Field data that ends with specific characters |
% followed by the characters |
%e will return records that end with lowercase e |
Field data that contains specific characters |
%characters% |
%r% will return records that contain a lowercase r |
Field data that contains NULL values (not existing) |
^ |
^ will return records that contain a NULL value |
To perform a find using a range of information, see the section Finding ranges of information.
NOTE: In most SQL databases, an empty value is something different than a NULL value (not existing).