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' |