Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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'

 

 

Published:

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'

 

 

For an optimal Community experience, Please view on Desktop
Powered by Zendesk