Search Patterns (LIKE)
Search objects can be specified with so called wildcards.
There are three special signs that you can work with:
Wildcards | Description |
|---|---|
% | per cent sign |
* | star |
? | question mark |
Example 1: Search of all accounts that start with 3.
Search Object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3% | ACCOUNT like '3%'
|
ACCOUNT | 3* | ACCOUNT like '3%' |
Example 2: Search all accounts.
Search Object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | % | ACCOUNT like '%' |
ACCOUNT | * | ACCOUNT like '%' |
Example 3: Search all accounts that have a 4 in position 3. We assume that the account has 4 signs.
Search Object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | ??4? | ACCOUNT like '__4_' |
Example 4: Search all accounts that end with 35.
Search Object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | %35 | ACCOUNT like '%35' |
ACCOUNT | *35 | ACCOUNT like '%35' |